on 05-21-2011 4:12 PM
Hello, I understand the lookup function and how it retrieves the signed data from other applicaitons. but is there such function that can retrieve e.g. category ID of specific fact table record of another application?
thanks.
Hi,
You can use *SELECT statement. It can be executed on any dimension in your appset.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nilanjan, *SELECT statement to my understanding is only for pulling dimension members out of dimension table. I want to pull dimension member out of signed data of another application. e.g. here is signed data of 2nd application
Time Cateogry signed data
2011.jan actual 100
now what i want to do, is write a script logic in 1st application, that says...
In 2nd applciaiton, when Time =2011.jan, give me the value of Category.
User | Count |
---|---|
16 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.