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 |
Report Portal
Filter All Dimension Level for multiple Dimensions
Posted - 02/10/2006 : 04:34:53
