| T O P I C R E V I E W |
| saurav |
Posted - 02/10/2006 : 04:34:53
The cube report is based on a cube which has All Dimension Level enabled for its 2 dimensions. The Dimensions are Dim1 and Dim2. After the cube report was build, the All Dimensions Level for both the Dimensions showed up. I used the Filter option to remove All Dimension level for Dim1 and the formula that was created was as follows -
InStr(1,[<Dim1>.CurrentMember.Name,"All") = 0
I am wondering how can I not show Dim2's All Dimension Level. Please remember that although All Dimension Level can be controlled at the cube level, I don't want to update the cube but only change using Report Portal. When I tried to filter on Dim2, it gave me a syntax error.
Thanks in advance for the help,
Saurav |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 02/13/2006 : 23:54:57
Have you tried to drag a level instead of the entire dimension? |
|
|
Report Portal
