Posted on 2011-05-08
Last Modified: 2016-02-14
Hi Eperts,

I need to make cube includes one measure and 3 dimensions on one table only.
for example
Table (T1)
culomns : A - measure
                 B-  dimension
                 C-  dimension
                 D- dimension
can you give me the steps
Thank & regards.
Question by:samprg
    LVL 4

    Accepted Solution

    Hi samprg,

    Below is the sequential procedure to be followed to report the mentioned scenario above:

    1) Create three dimension tables B,C,D which have a primary key and the domain values. For example , if B is like a Country. Create a table CountryDim with the columns Country_key as primary key and CountryName as another column which stores the Country names which are domain values or master data for Country. Similarly for the tables C,D

    2) Create a fact table for eg , FactSales which have the columns Measure (can be named as per your requirements) and foregin key references to the Diimension tables' primary keys as mentioend in the point 1.

    3) After the creation of these tables, the Business Intelligence Development Studio when SSAS project is created would be able to generate the required schema for the cube.

    4) The SSAS in BIDS(Business Intelligence Development Studio) can able to recognize the dimension tables and fact tables automatically with an additonal time dimension attached while the cube is developed.

    5)Basically, this is a star schema in the database which is used in SSAS cube in SQL server. There is other schema as well which is called snow flake schema which has a dimension dependant on other dimension, but here it is not the scenario.

    Hope this is helpful to you. Please vote up or mark answer if it resolved the issue or functionality. Thanks.

    Author Closing Comment

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now