Blog

  • Home
  • MSBI
  • Conformed Dimension in SSAS with Example

Conformed Dimension in SSAS with Example

  • (4.0)
  • | 1508 Ratings

Conformed Dimension

  • This is designed to implement “Write Back” option
  • Here the data are 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 → scenarios
Name: PARTY __ SC → FINISH

Enhance your IT skills and proficiency by taking up the SSAS Training.

Dimension structure

Attributes → PARTY –SC → RC → Properties → Write enabled: true
SAVE, BUILD → DEPLOY
Dimension structure
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

Checkout SSAS Interview Questions


List of Related Microsoft Certification Courses:



Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close