Skip to Content
0
Former Member
Mar 29, 2011 at 12:32 PM

Query - data from two versions in the same column

12 Views

Hello

Let me share my business scenario. Maybe you will be able to help me to desgn a query I am looking for.

I have data in my Info Cube:

- Version (A for plans and B for actuals)

- Calendar Month,

- Sales Amount.

I would like to create a query which presents Sales Amount per every Calendar Month, but:

- Data of version B for all of the months before current one (actuals)

- Data of version A for the current one and all of the nex ones (plans)

In result I expect the matrix like this:

Calendar Month Sales Amount

2011.01 200 (it is taken from version B - actuals)

2011.02 300 (it is taken from version B - actuals)

2011.03 260 (it is taken from version A - plans)

2011.04 230 (it is taken from version A - plans)

2011.05 200 (it is taken from version A - plans)

Is it possible?

Cheers,

A.