I am trying to create an iput ready query. I have included all the characteristics of the Aggregation level in the query and given single selection conditions. I could see only one record after I execute my query, but its not ready for input. Please suggest me where I am deviating.
First execute your query in the designer (because for example in BEX analyser your query could be in display mode) and check whether it is ready for input.
2) If not ready for input, check all characteristics of your aggregation level (your query must be defined on a aggregation level!) are in the lead columns or rows, or have a unique value via the filter.
3) your key figures should have aggregation type summation (check definition info-object)
4) your key figures should not be a calculated key figure.
if not, please provide details of your aggregation level and the definition of your planquery.
I checked all and they are fine. I have included all the chars from the aggregation level into my query filter and restricted to single values using fixed values. If I see the data in the Actuals cube with the same restriction as of my query, I could see only one record and which is same as my query data. But still I am not able to enable my query as input ready. Please guide me in this. In my restrictions to the chars in the query, I have given '#' to few of my chars, does this matters!
In my aggregation level, a filter has been defined. My question is if in the filter(aggregation level) a restriction is defined suppose on fiscal year = 2006, can we create a plan query and change the plan data for fiscal year = 2007/2008?
with htese SPS there should be not problems, just to be sure, you could start using all Nav-Attributes also in your Query.
I suppose you have already checked that your key figures are set to plannable, that the query ist set to plannable.
Are you showing system messages? Are there any when you open the Template or Workbook?
Are you maybe locking yourself because you show the data also in the planning modeler?
Otherwise I suggest you start building you query fresh from scratch.
First use all characteristics in the lines and collumns, if this works, then start building restricted key figures and filter in the way you really need it.
filter - reminds me - do you use maybe the same char in both areas on the filter section of the query (I don´t know what it is called in english, I mean the first tab in query builder)? please use and restrict each char only in one of these areas.
I don't want to be rude, but 90% of these kind of questions are caused because of incorrect filters ... So to help this discussion please provide us full details of filter and aggregation level.
you need at least one variable in your query to have the variable selection screen displayed, from query designer right click your characteristic and 'restrict' and choose 'variables', or drag one from left side (expand characteristic) and drop to the characteristic in your query. not necessary the variable is mandatory input, 'optional' also ok, depend on your user requirement.
If you need to a query which has to ask the user to enter particular value/s to a particular characterstic/s ,while excuting it, then we need to take variables in the Query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.