If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to decrease the dcube size for the below ex?

Started by Radhika, 25 Feb 2010 07:58:25 AM

Previous topic - Next topic

Radhika

Hi All,

How can i decrease the cube size for the below ex:

I have a cube which is used by HR for brandwise budeting (macro level), cube has brands as dimensions (165 line items), verison (2 line items), Employee movement ( 5 line items, ADD, DEL, BDGT, Current, total), Serial dim having 60 Line items and grand total ( Each line item is nothing but employer), another dimension of 45 items.

total size of the cube now is 4.5million cells.

When the user wants to load the file using locallink @ web levelit throws the JCE run error says cube  size issue.

Then, i have reduced the cube to 2.5 million by removing 30 line items from serial dim, i was able to load the file.

Actually speaking we want all 60 line items in serial dim, the user wants to see the detail level as well as at grand total level.

How can i decrease the cube size with out deleting the line items? whether i can use this serial dim as virtual dim in any of the cal dimension? does it make sense?

Please find the screenshot enclosed as attachment.

Thanks,
R

aa2288

One of the dirty menthods is to remove one of the version. The size of D-Cube would become half and create another d-cube for version 2 with dlink, admin link or system link between versions.

craig_karr

What dimension do you have as elist? Is it possible to create rules which dimension items in the large brand dimension are needed for each elist item? In that case you could cut down the cube using no data access tables

Preethi

The elist consists of 2 dimensions, thats all.


lav4you

Quote from: Radhika on 25 Feb 2010 07:58:25 AM
Hi All,

How can i decrease the cube size for the below ex:

I have a cube which is used by HR for brandwise budeting (macro level), cube has brands as dimensions (165 line items), verison (2 line items), Employee movement ( 5 line items, ADD, DEL, BDGT, Current, total), Serial dim having 60 Line items and grand total ( Each line item is nothing but employer), another dimension of 45 items.

total size of the cube now is 4.5million cells.

When the user wants to load the file using locallink @ web levelit throws the JCE run error says cube  size issue.

Then, i have reduced the cube to 2.5 million by removing 30 line items from serial dim, i was able to load the file.

Actually speaking we want all 60 line items in serial dim, the user wants to see the detail level as well as at grand total level.

How can i decrease the cube size with out deleting the line items? whether i can use this serial dim as virtual dim in any of the cal dimension? does it make sense?

Please find the screenshot enclosed as attachment.

Thanks,
R

Hi Radhika,

I am assuming that there are only two items for e-list which not included in 4.5 million calculation..

I have used this size cubes several time in many environment and it works fine on contributor with little slow performance, while data entry on version 8.4 and 8.1 as well
just check whats ur server configuration, ram and planning version...

nevertheless for size there is just a wild thought that you can spilt the cube by using logical grouping of brands and create 2 or 3 small cubes can solve ur problem ..