default view for OLAP cube when first accessed

Hello,

I am using MS Analysis server for OLAP cubes and viewing these cubes using Cognos. What I want to do is to have defualt view defined for the particular cube whenever it is first accessed. I have been able to set the default month (i.e. current month). But in the default view I want data shown across multiple dimensions. E.g. on first view my client should be able to see data against dimensions Date and Product nested on y-axis and dimensions Destination and Time nested on x-axis.

Is it possible to achieve this using MDX query?

Any ideas will be greatly appreciated.

Thanks,

Akber

Hello!

I think that this can only be achieved if you have a client tool that supports writing MDX queries/selects. You cannot do it directly in AS2000 or SSAS2005, you will need a client. Cubes are not repositories for reports.

Since you are using Cognos you will have to rely of this supplier's tools for creating and saving reports.

HTH

Thomas Ivarsson