Skip to Content
0
Former Member
Nov 06, 2008 at 11:04 AM

OLAP Lookup based on property

34 Views

Hi,

We want to create a special FX-translation logic that gives us a weighted average translation. We have 2 YTD applications that are called Finance and Finance Supplement. Finance is reported every month and Finance supplement once a year. We want to base our Average FX-Translations in Finance_Supplement on what is recorded on a specific account in the Finance application. This works fine with an OLAP LOOKUP, but when we want to change "Scope" to dynamically look up what the Parent has reported in finance we get a problem (see bold part of logic code).

//Lookup Account in Finance Application

*olaplookup Finance

*dim Intco = "All_intercompanies"

*dim Category = "Actual"

*dim Account = "Finance Account A"

* //How Do We Use An Entity Property To Get The Right Scope?*

* //The two applications share Entity dimension but we want to look up the parent in Finance app, not the one that is reporting in Finace_supplement*

* //We have a Property that defines the parent but we are not sure on how to use it in the OLAP Lookup?*

* *

* dim Entity= Entity."Property"??

//Swedish Currency, Used To View Consolidated Translated Figures (Group Currency)

//Local Currency

*dim Look1 :Rptcurrency="Sek"

*dim Look2 :Rptcurrency="Loc"

*endlookup

*when Account

*is Finance_supplemnt_account_b

*rec(Expression = %value% * (Lookup(Look1) / Lookup(Look2)), Account = Finance_supplemnt_account_b, Rptcurrency = Sek)

*endwhen

*go

*commit

Is there anybody who knows how to include a property in an OLAP LOOKUP function? We would be really thankful for any help.

Best regards

Robert