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
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.
Bringing Allocated Resource from another cube
-
- MVP
- Posts: 3652
- 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
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.
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.
-
- 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
Thank you....!