Blog

Conformed Dimension in SSAS with Example

Conformed Dimension

  • This is designed to implement “Write Back” option
  • Here the data written back to the data sources.
  • Scenario dimension performs many operations, one among the operation is “WRITEBACK”

Steps:
1.  Create a table in data source (Eg:- PARTY)
2.  Add the table in data source view
3.  Dimensions → new dimension →
use an existing table
Next
Data source view: TexttilesL_DB
Main table: PARTY
Key columns: PARTY ID, PARTYNAME
Attribute Type → other → scenario
Name: PARTY __ SC → FINISH

Dimension structure

Attributes → PARTY –SC → RC → Properties → Write enagled : tru
SAVE, BUILD → DEPLOY

Add row data like below party id party name party loc 4 madhu  hyd
Once you change your mouse location to another row. The row saves in the party table

                         Enroll for Live Instructor Led Online MSBI TRAINING


RELATED COURSES

Get Updates on Tech posts, Interview & Certification questions and training schedules