I just want to flow Grand total of a 5d cube to another cube having same dimension .
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.
Thanks and regards,
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.
Two cubes having the same dimension .
In Target cube i want every value to be the same (ie. the grand total of source cube)
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
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)
Yes Brendan Broughton i want every value in that cube to be the same (ie. the grand total of source cube)
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!!
Malav Shelat Brendan Broughton Thank you so much. both of your suggestion helped me.
Candra Aji Pamungkas
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
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
Retrieving data ...