Skip to Content
0
Former Member
Nov 24, 2009 at 08:54 PM

OLAPLOOKUP - pulling two parents to record the value

21 Views

Hello,

I am trying to write Script logic to take values from an Account node and a Cost Center Node and write the vlue found there to a different Data Source. Everything i try results in numbers I cannot fathom.

From:

AcctNode1 = Customers

CCNode = Seattle

DataSrc = Input

To:

Account = 123

CC = 88888

DataSrc = Alloc

*OLAPLOOKUP FINANCE

*DIM V1:AcctNode1= "Customers"

*DIM V2:CCNode = "Seattle" // Seattle MARKET

*ENDLOOKUP

*WHEN something

*IS something

*REC(not sure what)

*ENDWHEN

Thanks for any help you can provide...

Cheers,

Mark

Edited by: Mark Tyson on Nov 24, 2009 12:54 PM