Skip to Content
0
Former Member
Nov 07, 2007 at 03:13 PM

how to make key date of query as transcation date in cube

48 Views

I am facing an issues in displaying the transaction data with time dependent master data.

I want to set the key date of the query to go against the transaction date and diplay the respective master data.

I read in other posts,

that i cant use the user exit variable, because the exit is executed only once before the query run.

The fllowing is the report i want to achive,

customer|customer_grp -|date-| --|sale

100---- -|-sa


|jan 1|--- 15$

100---- -|-ic


|oct 1|--- 32$

in the above scenario, customer_grp for cusotmer 100 is sa from jan - mar and

customer_grp for cusotmer 100 is ic from apr - dec

I have customer_grp as time dependent attribute of customer. when i execute the report with key date as ,nov 1st

it displays as,

customer|customer_grp -|date-| --|sale

100---- -|-ic


|jan 1|--- 15$

100---- -|-ic


|oct 1|--- 32$

if key date is jan 1st it displays as,

customer|customer_grp---- |date-| --|sale

100--


|-sa
|jan 1|
--- 15$

100--


|-sa
|oct 1|
--- 32$

let me know whether it is possible to achive this type of report

-thanks in advance

- points will be awarded for inputs