on 08-14-2015 2:10 AM
Hi,
Is it possible to input the data at Hierarchy Node level through IP query?
We have the Hierarchy in BW where the node levels have the rolled up values from the leaf/child nodes. So, using this hierarchy in Input query, can we have ability for user to input the plan data at node levels?
Fyi, The planning related options of the hierarchy in the Bex query are DISABLED.
Please advise.
Thank you.
yes, this is possible.
there are more threads here in SCN about this topic.
regards
Cornelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
in the previous answer Cornelia is talking about disaggregation, you have found one setting in the Query Designer not supported on the server that is a very special case of disaggregation (special handling of posted hierarchy nodes and the corresponding leaf value that carries the 'rest value').
So you can use disaggregation (setting of structure elements) and enter values on hierarchy nodes, total and sub totals: these values will then be disaggregated to the level that is determined by the aggregation level used in the cell.
Regards,
Gregor
Hi,
the message comes from master data checks at run time of a query or planning function; this has nothing to do with the disaggregation setting. Check the master data values for the characteristic mentioned in the message RSPLS_CR009 and check also the hierarchy. You may use RSRV to do the consistency checks for this characteristic.
Regards,
Gregor
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.