BEX: Make a report with all the history of historized masterdata

[Former Member]

Hi,

anybody has got an idea how to make a BEX report

on a historized masterdata infoobjects,
being able to review all the history of the masterdata,

not only for one defined reference /due / cut off date a single masterdata dataset ?

Would be helpful  - ThanXs !

Martin

[former_member223480]

Hi Martin

If your query is based on a master data infoobject then run it without a restriction on the date.

But if your query is based on transactions then i assume you have a restriction on the transaction date. I don't know what will happen if you select on the query designer on the extended tab of your infoobject the result values to come from the master data.

Thank you

Yiannis

[yasemin_kilinc]

Hi Martin,

I don't think that it is possible with a standart procedure. Though, you can create a datasource from the time dependent master data to an infocube or DSO where you have 0validto and 0validfrom and other attributes as characteristics of this infoprovider. Then you can create a query on this infoprovider.

Hope it gives an idea

Regards

Yasemin...

[former_member182470]

Do you mean Time Dependent Master data? If yes, your Master data must have Valid from and To dates maintained in your system. Then, you can use Key date to show Time depe master data in Queries.

[Former Member]

Hi,

yes:  I mean "Time depe master data in Queries!.

no: the question was to see all the masterdata datasets (belonging to a compound) in Analyser not one by "Key date"

ThanKxs

Martin

[former_member182470]

Have you tried checking your report without using Key date?