Projection Datas

[gabrielkalb]

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?

[tjohnson3050]

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 :)

[gabrielkalb]

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?

[tjohnson3050]

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.