Hi, can anyone help me with a problem in report studio v8.2
I have a list report from a cube to which i have added calculated column. The calculation can only be applied at the type level to get the correct result:
Date Type Inc Total True_Inc
01/11/09 ex 1 10 1
01/11/09 pr 10 10 0
01/11/09 sf 5 7 5
The formula in true_inc is if inc=total then 0 else inc
What I want to do is then have a second report based on the result of this list report which adds the true_inc by date. However each time i try the second report returns the result = to the total of inc not true_inc. It obviously is rebuilding the formula at the consolidated level.
Is there anything I can do or do I have to redesign the cube?
Any help welcomed.
Smokey
Where did you use this formule.. in Report Studio or in Transformer.... ?
Quote from: Smokey on 24 Feb 2009 02:45:39 PM
The formula in true_inc is if inc=total then 0 else inc
Its in report studio as a calc column, originally the report was directed at the datawarehouse table. I'm suprised you can't have sub queries in a report which can be used by another query.
I've now created a cube in transformer to do the work but it's still not quite right... i'll keep at it....calculating at the summarised level based on the detail is causing me problems.
On a different report but same principal, would using conditional formatting to render rows hidden if true be expected to slow the run time of a report considerably?