How to look up Dimension IDs from other application's Fact/Signeddata table

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

You can use *SELECT statement. It can be executed on any dimension in your appset.

Hope this helps.

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

I have posted the reply in another thread of yours:

Hope this helps.