Map time-dependant navigation attribute to transaction data 0calmonth in BW4

[Farouk_]

BW3Hello BW community

I have a problem to map time-dependent navigation attributes to transactional data. I would like to drill down with year / month (0CALMONTH) on the rows, and I need to get for each month the corresponding attributes which are valid for the month from master data. Currently, the system gets the recent values from master data. I tried to use a key data in the query according to the value entered from user, but it works for a specific date but not for all months. 

For Master data, I am using both ADSO and tried to join it to transaction data coming from acdoca in Composite provider, or I can use an info object with time dependent navigation attributes and join it with ADSO transactional data in composite provider too.

please advise

[Giri2804]

Hi

Use Temporal join in composite for time dependent master data join.

Using Temporal Joins | SAP Help Portal

Regards,

Giri

[Farouk_]

Hi Giri,

Temporal Join should work as you suggested, but my Composite Provider is Using Union. Union Node is not allowed as below. I got exactly this error message referring to Union node. I used a aDSO for the master data and derived 0calmonth from the date from and date to. I crated two fields for month from and month to. After that in join condition, I used 0calmonth coming with transaction data to join it in between month from and month to driven from master data. It worked like this. What I should try to create another Composite provider with temporal join and use this composite provider in the other composite provider which includes Union node. May be like that, we get rid of this limitation below of using union node. BR, Farouk

Prerequisites

The following restrictions apply:

• Only InfoObjects and DataStore objects are supported.
• Union nodes, aggregation, and projection are not allowed.