March 15, 2011 at 12:20 pm
Hi, I am new to AS
I have to create cube with some dimensions.
I have to create two dimensions (A and B) which are the columns in the Fact table.
When Iam trying to create the Dimension, I am able to create the dimension with the Facttable name and the columns (A and B ) coming as an attributes for the that dimension.
I need A(column in fact table) and B(column in fact table) dimensions.
Need an help
Thanks.
March 17, 2011 at 11:14 am
any suggestions!
March 18, 2011 at 1:06 am
Why can't you just create two dimensions based on the fact table that just uses the attributes you need?
A small question: why are your dimensions in your fact table? Are they degenerate dimensions?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply