want to flow 5d cube grand total to another cube of same dimension

Ravichandra Aj

Hello Community,

 

 

I just want to flow Grand total of  a 5d cube to another cube having same dimension .

 

Jonathan Baetens

Brendan Broughton

Giulia Biondi

Previous Member

Hi Ravichandra Aj,

 

I would be able to help you if you can share a screenshot or a rough sketch of what you have and expected outcome.

Brendan Broughton

Hi Ravichandra Aj, not sure if I'm missing something but I don't quite understand what you're trying to do.  If the target cube has the same 5 dimensions, are you saying you want every value in that cube to be the same (ie. the grand total of source cube)

Ravichandra Aj

Yes Brendan Broughton  i want every value in that cube to be the same (ie. the grand total of source cube)

Ravichandra Aj

Two cubes having the same dimension  .

In Target cube i want every value  to be the same (ie. the grand total of source cube)

Previous Member

Hi Ravichandra Aj,

 

I am able to get this requirement through procedures, having cube with Same multiple dimensions, Time entities play important role when you want to flow Grand total to another cube with same dimensions.

 

for example to get this output through data flow below:

 

i followed this steps:

 

1. Go to Procedures > Create New Process > Select Data Flow > and refer this setup:

 

Here Lots is Source Cube

LotsTotal Target Cube 

 

2. Select Source Cube (here: Lots) > Go To References > Total BY > Month (Select as per your Time entities Settings)

 

 

3. Simple Setup here:

 

 

Run the Procedure and here is the output:

 

 

 

Hope this helps!!

 

Thanks and regards,

Malav shelat

Brendan Broughton

Hey Ravichandra Aj, so that means you want every value to be the same across all time periods correct? A few ideas below

 

If you DON'T need it saved to a cube and only need it within a dataview you could use GT(a) as your algorithm. I don't believe it will work in a dataflow though, but not knowing exactly what you are needing to show it might be useful in a dataview.

 

Otherwise if you need it in a cube you could dataflow to an interim cube first to remove the 5 dimensions. You would dataflow to an interim cube which has a single dimension (lets call the entity/dimension 'TEMP'), and that dimension on has one 1 entity member. That will essentially store the grand total in that cube, which you can then dataflow to your target.

 

The other option is to add 'TEMP' as a dimension to your SOURCE cube (making sure you can still populate it), and then in the References tab of the source cube in the Dataflow put 'Total By - Temp'.  Then Target = Source.

 

Hope that helps a bit

Ravichandra Aj

Malav Shelat Brendan Broughton Thank you so much.  both of your suggestion helped me. 

Abdul Malik

Candra Aji Pamungkas

Jadi PEKIK

Hi Rav

I try to understand your question, that you only want to transfer value from 1 cube to another cube with the same dimension, so you can do:

1. create cube with the same dimension

2. you just assign cube a to cube b

3. then cube b will have exactly value with cube a

 

Please feel free to contact us if you have additional information, you can capture of your screen also for make us answer your question properly

 

Best Regards

Abdul Malik

Previous Member

ezeming

Ravichandra Aj

i wanted every value in second cube to be the grand total of first cube which Malav Shelat has answered to my question with example above

Previous Member

Hi Ravichandra Aj , in My reply you can Go to Actions > Mark as Correct, so that this question will fall into resolved category and you will not be having any more answers.

 

Cheers,

 

Thanks and regards,

Malav Shelat