Query on transactional ODS possible?

[Former Member]

Hi,

we have a process of master data maitenance by end-user.

in order to capture the changes, we are using transactional ODS.

But, now, we have a requirement to report on transactional ODS to see who has made changes & when the changes are made.

I'm not able to create a report out of transactional ODS. Did anyone face the same problem?

Is this a problem or is that the way it works?

need to mentione about our versions & We are on BW 3.0B & SEM 3.1B.

If we can't write a report on Transactional ODS, then what is the purpose of the same?

Thanks,

Hari Immadi

http://immadi.com

SEM BW Analyst

[Former Member · Accepted solution]

Hi Hari,

I have not worked on Transactional ODS..

But theory says that We cannot report on a transactional ODS.

To report on a Transactional ODS we need to create an Infoset with it and then report on the Infoset..

Hope this helps

Let me know..

Ashish..

[Former Member]

Hi Hari,

As Ashish has rightly pointed out, check the help link below it clearly mentions

<i>"You cannot set the indicator for BEx Reporting when creating a transactional ODS object. In order to report this, you can create an InfoSet and then create a BEx query for it."</i>

http://help.sap.com/saphelp_bw30b/helpdata/en/c0/99663b3e916a78e10000000a11402f/frameset.htm

Hope it helps.