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

[Former Member]

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

[former_member242420]

Hello,

I have the same kind of requirement.

Is it possible to assign a Date field from the cube to Keydate of the query so that the time-dep attribute value is properly displayed based on InvoiceDate of each record, not based on today(query keydate by default)?

Otherway i can think of is to add a Char/KF to cube and insert the value using a query on Masterdata in update rules. How far this approach is recommended?

Thanks in advance,

vamsi.