cancel
Showing results for 
Search instead for 
Did you mean: 

No data in OLTP Reports

Former Member
0 Kudos

Hello ,

I have a problem about OLTP reports. I have configured Interactive Reports by installing another client(reporting) on existing CRM2007 system.

I created an custom OLTP report from a realtime cube ( tec.name is /CRMBW/CSAL_C01 ). But I get 0 record.

We have two clients in a same server. Client 100 is CRM and Client 300 is BW.

I checked OLTP datasource ( /CRMBW/OLTP_ACTIVITY ) in CRM in rsa3 tx , but I got 0 record again.

I assigned all profiles and roles the system user and I set parameters in sbiw.

Please answer :

1 - Should I get data in CRM ( in rsa3 ) from this datasource ?

2 - How can I checked data from this datasource ?

3 - I created an infopackage but in Data Targets tab, there are no data targets. is it normal ?

Regards,

Blue

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

HI..

You should get data from CRM data source in RSA3...because if there is no data there...u cant expect data flowing here into it..

Hope u got me...

2 - How can I checked data from this datasource ?

Go to the underlying table on which ur data source is built..

then in SE16 ..check for the data by putting the table name there..

3 - I created an infopackage but in Data Targets tab, there are no data targets. is it normal ?

Have u created the updat Rules for this...

and without Data Target,,,how can u expect data flowing into ur data target..

First create update rules..then the data target will be visible there..

Hope this helps u..

Best Regards,

VVenkat..

Edited by: Venkata Narayana Jakkampudi on Jan 16, 2009 8:16 PM

Former Member
0 Kudos

Hello Venkata ;

Thank you for your quick answer. I didn't create any update rule because I use an OLTP infocube. Just I created transfer rule and I activated in BI content also.

I tried to create an update rule but I got an error : " InfoCube /CRMBW/CSAL_C01 can not be used in the update rules."

I think OLTP info cubes are different from others.

What should I do ?

Regards,

Blue

Former Member
0 Kudos

Yes Exactly..

Cehck this link for more info reg the Real time Info Cubes..

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/39/100c38e15711d4b2d90050da4c74dc/frameset.htm

Hope this helps u..

Best Regards,

VVenkat..

Former Member
0 Kudos

Yes but this link about Real time infocube for planning. OLTP cubes are different I think.

Should I create an update rule anyway ? But I couldn't and got error.

Former Member
0 Kudos

Hi,

As far as my knowledge goes,,,u need to create update rules...

I am afraid that,,i cant help u..in this scenario..

Best Regards,

VVenkat..

Former Member
0 Kudos

Ok thank you anyway..

Regards,

Blue

Former Member
0 Kudos

Hi

Are you able to resolve this, I am facing the same situation.

Pls help.

Thanks..

Lokesh