on 07-21-2014 2:17 PM
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
Do you also display the current data (yellow request) in your input-ready query?
It's also not filtered out?
Regards,
Jürgen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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:
| ||||||
|
| |||||||||||||||||||||||||
|
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.