Sign In






All Tags » Formula (RSS)

Browse by Tags

  • connecting two tables in more than one way

    Hi, I have table one sessions table (A) and events table (B). They are connected i ElastiCube by connectionId. 1. In some cases, I also want to connect them by different field: A.mac_address and b.param. Unfortunately, b.param is used for many things, and may also be null. If i add the second join in...
    Posted to Known Issues & Workarounds (Forum) by Marina on 11-23-2011

  • Working with multiple tabels

    Hi Experts, Is anybody know how to handle multiple tabels? for example, I have create data with multiple tabels. Each tabel contain different data. How to relate the dimension of one table to the other table? Please go through the SQL query. SELECT T1.CardCode, T1.Street, T1.Country FROM OCRD T0 INNER...
    Posted to Known Issues & Workarounds (Forum) by Amit Tyagi on 01-14-2009

  • Working with mulltipe and tabels

    Hi Experts, Please can any one share their experience regarding how to create reports in prism because all the componets are new for me. Please send me the document in which there have to be some examples. Regards Amit Tyagi
    Posted to Known Issues & Workarounds (Forum) by Amit Tyagi on 01-09-2009

  • Excel "in cell" formulas

    Many users use in-cell formulas to calculate values, on which they perform their analysis. Prism works great with in-cell formulas because it generally references the value of the cell, not the formula that creates it. However, you need to pay attention to TYPE of value your formula returns. For example...
    Posted to Known Issues & Workarounds (Forum) by Elad (SiSense) on 09-10-2008

  • Adding a second Y Axis to a chart

    From a user: I have a column chart with months from a Purchase Date dimension on the axis panel and a Sales measure as the series. Question 1 : How do I create a formula to calculate the average sales per day, for each month? Answer 1 : Full explanation can be found here: http://community.sisense.com...
    Posted to Prism Issues (Forum) by Elad (SiSense) on 09-04-2008

  • Handling currency conversions

    Ok, this one isn't from me, it's from one of our users who wanted to show us how he handled currency conversions with Prism. Thank you! I've simplified his scenario, just to get the main point across. Note that this user was working with Excel files, but this example is just as valid for...
    Posted to Prism Business Intelligence Tools - Tips and How-to's (Weblog) by Elad (SiSense) on 05-07-2008
Page 1 of 1 (6 items)