I want to get all the country names from a cube where another Key figure is NOT equal spaces or zeros. Please let me know if some one can help me.
My Cube is CFS_PERF/CFS_PERF_CFSPERF_GL
Want to get 0PAYER_COUNTRY where
[Measures].[3M1DTA8FO1HVYVOI6HUABEXHX] is NOT equal to zero
Please help !!!
Try this:
SELECT [Measures].[3M1DTA8FO1HVYVOI6HUABEXHX] ON 0,
NON EMPTY [OPAYER_COUNTRY].members ON 1
FROM CFS_PERF_CFSPERF_GL
No comments:
Post a Comment