Reporting Agent versus Query

[Former Member]

Hi,

I run a query in the BEx by selecting 2 cost centers A and B and I receive both results.

When I execute the job with the reporting agent I receive only the first cost center.

How can I debug this ? Any idea what could be the reason ?

Thanks for your help,

IE

[Former Member]

Hi,

Check whether you have restricted the Cost center data while creating scheduling package in the reporting agent?

Thank you

arun

[Former Member]

If so, you need to make sure that the 'expand to level' item in bex on that hierarchy infoobject is set to the lowest level you want it to open to - or else RA in not force the hierarchy to expand.

[Former Member]

Hi Adem,

The query gives the expected results.

The problem is that the reporting agent doesn't give the result of one cost center. I use the reporting agent to print the results of the query.

Cost centers are given as a selection in the query.

Any idea ?

Thanks,

IE

[Adem_Baykal]

Hi Ingrid,

are there any variables used in your query?

That sounds a little bit strange.

What exactly you did? A precalculation, print or anything else?

Regards,

Adem