April 16, 2012 at 12:47 pm
Hi All
I have to create a new dimension and the main reason is i wanted to use it in the report and its not a measure , but its part of a FACT table. I need to create a dimension "Address". This field already exists in a FACT table (P_FACT), PRIMARY KEY is CASE_NUMBER.
And i followed the following steps:
1) Opened BIDS, Right clicked , create new dimension and DIMENSION WIZARD Opened.
2) Select Build Method ( i chose "attributes only") .
3) Select the data source view and i selected the corresponding DSV that i needed.
4) Dimesion Type (Selected the standard type)
5) Select the main dimension table and in the drop down list i selected the (P_FACTS) table, and in the key columns i selected the "CASE_NUMBER" .
Column contatining the member name(optional)-- i left it blank.
6) In this step of "SELECTED RELATED TABLES" i didnt chosse any and went to the next step.
7) In this step "SELECT DIMENSION ATTRIBUTES" , i selected "PRIMARY_ADDRESS".
8) In this step "SPECIFY DIMENSION TYPE", i selected "REGULAR"
9) In the next stpe where it asks "DEFINE PARENT CHILD RELATIONSHIP", i clicked next as each CASE NUMBER should have a PRIMARY ADDRESS and they are not PARENT CHILD relation.
10) Next step was "Scanning dimension tables...
Permit FACTS: All relationships detected.
- Dimension Wizard examined all relationships but did not create any hierarchies.
11) Final step i named the DIMENSION and PROCESSED the DIMENSION. PROCESS SUCCED.
But when i opened the DIMENSION and selected the Browser tab i could see only one field at a time, i mean in the heirarchy level drop down i see two fields (one is named as the table name PERMIT FATCS, but when i select it it shows me the case number's) -- how can i change the name to CASE NUMBERS, secondly is there a way where i can see CASE_NUMBER and PRIMARY_ADDRESS fields next to each other?
Finally how can i add this dimension to an existing CUBE?
Please need help or advice.
Thanks
April 17, 2012 at 1:08 am
In the dimension browser, you can only browse the individual attributes of your dimension. If you want to see them side by side, you can create an attribute that combines both in the data source view, or you can put them together in the cube browser or in any other client tool.
You can rename the attribute in the dimension structure tab. Select the attribute and hit F2.
To add the dimension to your cube, open the cube editor and go to the Cube structure tab. In the left bottom you have to cube dimensions window. Right click on the cube and select Add Cube Dimension.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply