Input ready query shows incorrect data after closing request ID

[Former Member]

Hi,

When I manually close request IDs, the input ready query does not show correct data.

Either, it shows blank data or either it behaves very inconsistently.

We have upgraded to the highest version of patches and tried a few settings with the cube or with the query. The Input query is created using Aggregation level/filter. We are also using the audit trail exit. I also looked at OSS notes and tried the standard settings. But it does not work.

Would you have some useful inputs regarding that issue.

Thanks a lot,

Patrick

[gregor_dieckmann · Accepted solution]

Hi Patrick,

check whether note 1179076 helps. Delete also the cache of the plan buffer queries <PROV>/!!1<PROV>, <PROV> = InfoCube or MultiProvider used.

Regards,

Gregor

[Former Member · Accepted solution]

Hi Gregor,

Thanks for your answer.

How can we delete the OLAP Cache of the query? Is there any standard setting that can prevent us to do that. We are a patch level 17/ 7.0. We are not using any multi-provider.

Thanks a lot,

Patrick

[gregor_dieckmann · Accepted solution]

Hi Partick,

you can use RSRT and press the button 'Cache Monitor' or you can directly use transaction RSRCACHE. There press the button 'Main Memory'. In the context menu of the nodes you can find the delete function.

Regards,

Gregor

[Former Member · Accepted solution]

We have implemented OSS notes and it works fine now.

Thanks a lot,

Patrick

[former_member202229 · Accepted solution]

Hi Patrick

Which notes did you implement?

Regards

Pieter

[Former Member · Accepted solution]

Here are the notes:

0001125037

0001144702

0001149083

0001149660

0001161111

0001176585

0001179076

0000616678

0000622019

0000624236

0000625796

0000625840

0000628752

0000972340

0000972341

0000973272

0000973273

0000974926

0000980063

0000980309

0000991733

0000991766

0000991809

0000991997

0000994721

0001005933

0001005934

0001006144

0001006146

0001018737

0001018839