Filter information Analysis Studio

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