Initial Data through planning query
I have a input enabled query, when executed it displays 'no data' instead of allowing me enter values. I couldn't find much info on sdn except one thread that advises to use either RSINPUT or 2 structures in the query.
Could you kindly let me know the best approach to enter initial planned data(dummy data).
Using Version characteristic, planning and actual will be differentiated in my scenario.
I am using IP with BI 7.0
Thanks for your help and points will awarded upon helpful advise.
Danny Wong replied
Basicly you need the "All possible Combination swtich on" in your input enable query. The idea is the same as in BPS.
e.g. for all your rows and column, you need to set to Master data or Characteristics Relationship in the Advance tab in the query builder . Be careful with the number of characteristics in rows or columns as the the conbination can be huge and it will slow down the query. Use relationship if there are specific rules to limit the number of combination, so not all the values from Master Data need to be generated.