I have a dimension (Customer)
I need Analysis studio don’t include a specific member of Customer when in rows and columns i am querying the Cube thru another dimensions.
For examples sales for region in rows (Europe, Asia, America, etc) and Date in columns, but i need analysis studio don’t summarize the sales for germany.
i created a report simular as you described, but with other dimensions.
- i just used the hide function to hide the summary.
- selected all the nested rows
- created a new calculation for the selected rows.
save the report to keep the report changes
below is a example
as you can see cognos set in the context filter
Cuenta = 200200, but how can change to
cuenta <> 20002000