cancel
Showing results for 
Search instead for 
Did you mean: 

Values are saved in the cube, but not displayed in BI-IP Query

Former Member
0 Kudos

Hello guys! Hope you are all doing fine!

It's been a long time I don't work with BI-IP, and now I have been facing a problem... Hope you can help me out:

BW Version: 7.31

I have a query based on an Aggregation Level.

When I input values in the query, these values are saved in the infocube, however, they are not displayed in the input ready query. They are only displayed in a regular query.

Do you guys have any clue of what I am doing wrong?

Thanks in advance,

Cristina

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Do you also display the current data (yellow request) in your input-ready query?

It's also not filtered out?

Regards,

Jürgen

Former Member
0 Kudos

Jürgen,

Yes, but even closed requests are not being displayed in the input ready query.

Thanks,

Cristina.

Former Member
0 Kudos

Then I think it'S a filter issue, do you use some derivations and probably filter them out?

Hard-coded filters which don't match the data? Wrong infoprovider restricted?

Try to display data with TA listcube on your aggregation level with filters of your query.

Regards,

Jürgen

Former Member
0 Kudos

This is really a simple model, I don't understand what could be wrong,

The infocube contains the following characteristics and KF's:

Char: CA_CICLO, 0RT_ASORT, 0CM_STRAT

KFs: KF_PESOVL, KF_PESORC, KF_PESOMG

The aggregation level is set up exactly with the same chars and KF´s...

The filter is set as:

0CM_STRAT = #

0rt_asort = (variable Optional, Selection Option)

ca_ciclo = (variable Optional, Selection Option)

The query contains this filter.. and is direct input, no formulas, nothing unusual...

Thanks,

Cristina

Former Member
0 Kudos

There is another weird behavior:

The query brings the cells empty, however, when I click on Key Figure definition, it shows me the amount that is saved in the infocube...

It shows me two warnings:

"The key figure definition may not display the correct value for KF_PESOMG"

     "The (part ) InfoProvider NA_HPTSTK is a service routine (virtual InfoProvider). because this

         calculation can depend on context, the value of the key figure definition can deviate from

          KF_PESOMG"

"Read mode X taken over from query"

Does this ring any bell?

KF Definition Screen:

Messages:
The key figure definition may not display the correct value for KF_PESOMG
Read mode X taken over from query

AssortmentL1C0501309
CA_CICLO201315
StrategyNot assigned
Key Figure Detail
KF_PESOMG20,000
      KF_PESOMG20,000
Former Member
0 Kudos

Hi Cristina,

if the keyfigure is part of a virtual provider, you can not input enable it.

The key figure has to be part of a direct-update cube or DSO, otherwise data can not be transferred.

But nevertheless all other keyfigures should be written. Or do you get an error message when you save? There should be yellow request and the data in your direct-update cube/DSO.

Regards,

Jürgen

Answers (1)

Answers (1)

0 Kudos

Hi Cristina,

if you change data and save and then you don't see the changes in the query this is a bug; there is a known problem with a similar symptom, check whether the following notes applies:

https://css.wdf.sap.corp/sap/support/notes/1997200

Regards,

Gregor

Former Member
0 Kudos

Hello guys!

Problem was solved with SAP notes:

1862648

1932524

1933331

1997200

Thanks for your help!

Cristina