Question:
hi,
i try to define a query as follows:
the query consists of a row structure with 12 columns, one for each month.
furthermore the query has a key figure that can be restricted to "actual" or "plan" values.
now i want to display two rows in the query result. in the first row i like
to display the "actual" values for all columns from january to CURRENT
month. the REMAINING columns should be EMPTY or filled with zeros.
the second row of the query result should be filled with "plan" values for ALL columns from january to december.
does anyone has an idea how to achieve this result without using the cell editor?
my problem is anything i define/restrict in the columns structure affects ALL rows. if i could differentiate between the rows from the columns selections my problem would be solved. or maybe there is another way?
thanks very much for your help!
Answer:
take the key figures out of your 12 structure componest (rows) so they are just restrictions. (they will look like characteristics)
then create an new structure for the columns with the 2 restricted key figures (plan and actual).
you may have to wipe out the 12 and rebuild them as characteristic stucture components
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
hi,
thanks very much so far. but this is not the solution. i must have
a structure for the the 12 columns because these queries are
used for charts.
yes i probably also have a row structure where i can restrict the
key figure on actual and plan values. but how can i achieve to leave
the remaining columns blank for the actual values beyond the current
month?
Answer:
Well... If you have actual values beyond the current month your problem is bigger than a simple technical method in BW. If the values are in the future, they cannot be actuals.
Leandro
Answer:
hi,
thanks very much so far. but this is not the solution. i must have a structure for the the 12 columns because these queries are used for charts.
sorry if i didn't understand your question. my solution will give you 12 columns and 2 rows fixed. maybe if you can type out a small mock-up of what you want it to look like i can help further.
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
sorry, if my questions wasn't clear enough.
i tried the following:
jan feb mar apr may jun jul aug sep oct nov dec
actual(cumulated) 1 2 3 4 5 6 0 0 0 0 0 0
plan(cumulated) 1 2 3 4 5 6 7 8 9 10 11 12
but what i get
actual(cumulated) 1 2 3 4 5 6 6 6 6 6 6 6
plan(cumulated) 1 2 3 4 5 6 7 8 9 10 11 12
i found already a solution for the case of non-cumulated values.
but in this case i can't avoid the actual cumulated values for jul to dec.
this query is required for a chart.
thank you very much!
Answer:
thanks for the mock-up, sometimes things make more sense to me when i can see them
what you might do is create an additional key figure in the row which is a boolean. when the non-cummulated "actual" value is zero show zero when the non-cummulated "actual" value is non-zero show the cummulated value. then just hide the actual accumulated. the problem, of course, is when you have no actual value for a valid month. you could also base the boolean on a key figure date, but it requires a few more steps.
maybe this is a start for you
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
thanks, i will try that.