Hello.
I need a report that have 3 columns:
ID | Day | Value
Think that "Value" is some calculation.
When i run the report i have the result:
ID | Day | Value
1 1 12
1 2 17
1 3 18
But i need to do a projections of this data, so how can i create more 2 lines in this report? to projection the value of day 4 and 5?
What logic are you going to use for the projected values (X)?
You could create a second query with data items:
ID | Day | Value
1 4 X
Union the first and second queries in to a third query
Create a fourth query
ID | Day | Value
1 5 X
Union the third and fourth query into a fifth query.
Of course, a better way to do projections would be to implement Cognos Planning or Cognos TM1 :)
Thanks!
I want to ask other question about this scenario.
Can i put a prompt that the user choices the number of new lines?
I need to do something like:
If user choice a projection of 3 days, so i need 3 new lines.
can i do this without TM1 or Planning?
That would be difficult. You would have to put together new queries for all the possible number of projections.
You could try to do it with a sql object using recursive cte logic.