Olap cubes

Last Post 01 Nov 2005 12:17 PM by vvenkat. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
vvenkat
New Member
New Member

--
01 Nov 2005 12:17 PM
Hi,

I have a fact table where two of its columns refer to the same dimension. I wanted to analyze the movement between these two columns.

Example:

columns:

ID region1 region2
1 tor ny
2 tor tor
3 tor miss
4 miss miss
5 miss miss
6 miss tor
7 ny miss
8 ny ny
9 ny ny

My cube should look like this:
region2
region1 tor miss ny
tor 1 1 1
miss 1 2
ny 1 2

What do i need to do?

Thanks a lot for all your help.

v


You are not authorized to post a reply.

Acceptable Use Policy