How to Transpose Time

building semantic layer
1

I have 2 Tables. Table1 has Last Year Measures, This Year Measures, Last Year Year 2 date, This Year Year to Date in different columns.

Table 2 has only Last Year Measures, This Year Measures but no Year 2 date in columns.

How will I jump from table 1 to Table 2 for YTD values since table does not have a column for that. Is there something we can do in designer which can accomplish this

ANy ideas will be appreciated

cravie (BOB member since 2005-04-20)

2

Hi cravie

Is impossible to tell you how can you accomplish this if you don’t give us any info about the dimension linking the measures.
Basically if the two tables have the same dimensions than if you get the same tables in the same report with two different Data Providers than you can link the dimensions and build a table using all measures you want to.

PS: Or i understood you wrong!!!
Aldo

AldoWeb :albania: (BOB member since 2005-05-24)

3

Not getting your requirement. can you provide more details such as sample data from both tables and what should be your outcome result set?

Rakesh_K :india: (BOB member since 2007-12-11)