I am getting a crossjoin in my query when I place the dimensions [Customer Type] and [Customer_Name] in the rows and the measure on the columns, all the customers are repeating for each customer type. To avoid this I can include NON EMPTY in my MDX query for example :
SELECT
{ [Measures].[Collateral Value] } ON COLUMNS,
NON EMPTY CrossJoin({ [Customer Type].[All Customer Type].Children }, { [Customer_Name].[All Customer_Name].Children }) ON ROWS
FROM [CUBE_COLLATERAL]
The problem is I have to surface the cube in the OLAP viewer as a data exploration, and since I am fairly a beginner in MDX i am not able to find a way how and where to specify the NON EMPTY during the cross join in the OLAP viewer or is there any way to create a custom measure/ member as a work around for this.
Thanks in advance.