Hi,
I want a default view set up in my transfomer model which was specified by the customer. Specific dimensions and specific measures must show up when the cube is opened. Can anyone help me out on how this can be achieved?
Thanks.
The left-most dimension will be the Columns and the next left-most will be the rows and the first measure in the list will be the measure, when a cube is opened by default.
Thanks for the reply.
But what I want is to show the 5th dimension and 6th dimension as columns and only 5 outof 10 measures must be the rows when the cube is opened. How can I get this???
Thanks.
If your customer is accessing the cube via a Cognos portal (Upfront or Connection), give them a saved view rather than direct access to the cube. Ditto if using PowerPlay client and you can either point them to a shared view on the network or if distributing it isn't too difficult.
If direct access via PPWeb is your only option, best you can do is rearrange your dimensions as rockytopmark's comment suggests, but you won't be able to anything like what you described.