Not able to save data in Input ready bex query (on top of Direct Update ADSO).

[former_member535495]

Hi Experts,

In my current project we have requirement to enter KPIs definition information (Like Name, Type, Scale, etc.) using input ready and direct update ADSO.

So, we have created flow as below:

1. Required Infoobjects (Without Master data).
2. Direct Update ADSO (with required I/Os).
3. Aggregation Level on top of Direct Update ADSO. (Aggregation contains all I/Os that available in ADSO)
4. Bex query on top of Aggregation with following settings:

1. Open in change mode.
2. All Key figures with Input ready and Disaggregation (Equal value).
3. All dimensions & key figures of Aggregation Level is available in row & columns.

While running this query in RSRT, query is opening in change mode and we are able to enter values but when we click on save button – First time it’s showing “Disaggregation not possible as reference not found” after that it’s showing nothing.

Please let me know if I missed something in development.

Thanks,

Girish Lakhani

[cornelia_lezoch · Accepted solution]

Hi Girish,

it sounds that you want to create new master data entries for one of your info objects.

If I remember correctly, Bex always had trouble with this.

Please create a new master data record either in RSRT or in master data maintenance.

Ist this one shown in your query and are the other fields 7 key figures now entry enanbled?

If yes, then the query is correct but then it´s not possible to create new master data in Bex.

Can you use a different frontend?

regards

Cornelia

[former_member589105]

Hi r u able to fix this Girish? as per Cornelia said can you create MD entry?

[former_member302041]

Can you please share screenshots of RSRT?

[former_member535495]

Hi Andrey,

Please find RSRT screenshot of Input ready query.

Thanks,

Girish

rsrt.jpg

[former_member302041]

Hi,

Not sure why you need (as I understand from the case) dis-aggregation...

Could you please remove it and see if it saves data properly (may be before save try to press "Transfer Data")?

[former_member535495]

Hi Andrey,

Thanks for quick response.

Yes, we have disable dis-aggregation. After that also same we are not able to Transfer/Save data in query.

Thanks,

Girish Lakhani