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

Help with writing rule

Started by EP_explorer, 07 Jan 2011 02:48:42 AM

Previous topic - Next topic

EP_explorer

I'm trying to write rule for next situation. I have 2 cubes. Cube A for simplicity with 2 dimension:
1. months (Jan, Feb,..., Dec)
2. measures1 (element1 (sum), element2 (Jan, Feb, ... Dec));

For example
              Jan Feb Mar Apr May Jun
element1   10   20  10  30  40   30
element2  Jan Jan Jan Apr  Apr  Apr

Cube B also contains 2 dimension
1. months (Jan, Feb,... Dec)
2. measures2 (element3 (sum))

I want to receive next order of date in Cube B
             Jan Feb Mar Apr May Jun
element1   40   0     0 100    0   0

So you can understand element 2 in Cube A shows month in Cube B where I want to allocate sum from element 1. Unfortunately I can't imagine how I can write necessary rule. Can anybody help?