Hi
I have a Cube with 7 Dimensions. One of them is User names Dimension.
Every User have Write access to his own Element in (S_Users dimension Eg: Matt Golman have write access matt element in Dim)
There is one Admin element in that dim which have Admin data in a cube .. no one is have Write to that Admin element.
Now i am creating a action button in Worksheets where if Matt logged in and press that
"Who press that button must load with Admin data.. to that perticular year and for that version which he have in his spreadsheet at that moment"
Approach:
I was beating around the idea to create a TI process with Parametes for User and year and then map that parameters into spreadsheet cell where matt and year is placed. But could not get exact idea to do this..
How can i make it happen??
Thanks for your time
Pull data from one element and load to other element
- vinnusea
- Posts: 116
- Joined: Thu Sep 23, 2010 6:12 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- Location: San Diego ,CA
Pull data from one element and load to other element
Thanks
Vinnusea
Vinnusea
-
- Community Contributor
- Posts: 132
- Joined: Thu Oct 15, 2009 7:45 pm
- OLAP Product: TM1
- Version: 9.4.1 9.5 9.5.1
- Excel Version: 2003 2007
Re: Pull data from one element and load to other element
there was a similar thread a while back:
http://forums.olapforums.com/viewtopic.php?f=21&t=1767
See if it helps.
http://forums.olapforums.com/viewtopic.php?f=21&t=1767
See if it helps.
Ankur Jain
- vinnusea
- Posts: 116
- Joined: Thu Sep 23, 2010 6:12 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- Location: San Diego ,CA
Re: Pull data from one element and load to other element
Hey Thanks this is exactly and looking for..
Appriciate your help
Appriciate your help
Thanks
Vinnusea
Vinnusea