Bringing Allocated Resource from another cube

Post Reply
dparkar
Posts: 7
Joined: Fri Jan 17, 2020 10:45 am
OLAP Product: Planning Analytics
Version: 2.0.7
Excel Version: 2017

Bringing Allocated Resource from another cube

Post by dparkar » Wed Jul 01, 2020 7:33 am

Hi All
I have a scenario in which i need to bring the name of the resource who is allocated
for example i have 2 cubes
Capture.PNG
Capture.PNG (175.75 KiB) Viewed 245 times
in the 1st cube there is an option for input, if we type 1 in front of Anne in allocated resource, then when we run the Ti Anne's name should appear in 2nd cube in the same combination.


Thanxx in Advance.

lotsaram
MVP
Posts: 3409
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Bringing Allocated Resource from another cube

Post by lotsaram » Wed Jul 01, 2020 8:16 am

Well, urrrm, what have you actually done?

The requirement you state is pretty simple. You just need a zero supressed view on the first cube with only the "Allocated Resource" measure selected. Then on the data tab take the variable from the Resource dimension and write it with CellPutS to the "Resource" measure in the 2nd cube.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

dparkar
Posts: 7
Joined: Fri Jan 17, 2020 10:45 am
OLAP Product: Planning Analytics
Version: 2.0.7
Excel Version: 2017

Re: Bringing Allocated Resource from another cube

Post by dparkar » Wed Jul 01, 2020 11:12 am

Thank you....!

Post Reply