Hi Friends Anybody ... If u have

[MacintoshF16]

Hi Friends

Anybody ... If u have solution for Creating Multiple Cubes using single Model.

I appreciate if u post the Script. Its very Urgent..

Thanks in Advance...

Regards,


Macintosh

 

[benbotektips]

You most definitely can create >1 cubes from a model. Simply create the 'master' model, with every dimension & measure you'd need, then create separate cubes (by going to the 'Powercubes' window and 'insert new cube'), then customize, by including or omitting dimensions, or creating a view (dimensions tab), and go to the measures tab and tell whether to include or exclude a dimension. Save the cubes under different names, and you got one model creating >1 cube. be sure to make a copy of the .pyi, and to save as .mdl. In fact, the recommended way is work on the .mdl and save as .pyi for database connection info, because .pyi's get corrupted, while .mdl files don't (they're metadata).
On a related issue, read the documentation on cube groups - a simple way to split a cube on any dimension with multiple values. For example, if you have a cube with data for 5 cities, you can create a cube group of 5 cubes, each with only its city's data.