This is possible in ways a) Without Template b) With the template
Solution Explorer → cube → new cube → next → o Generate tables in the data source template(None) Next → Add new measures Measure name measure group data type Aggregation Actual cost Text_Fact_new Single Sum Estimated cost Text_Fact_new Single AVG —- —– Next → Select dimensions from template Time———- Run new dimensions Name SCD Attributes Product 1 – – – – – – Location 1 – – – – – – – Next → next → Regular calendar
If you would like to become an SSAS Certified professional, then visit Mindmajix - A Global online training platform: “ SSAS Certification Training Course ".This course will help you to achieve excellence in this domain.
Dimension Measure Group1 Time1 Product1 Location1 Next → cube name: CB-Test Generate schema now → Finish → Next → Create a new data source view name: DSV_CB_TEST Data source: CB_TEST_DS [if required click new & specify —–] Next → next → next → finish → close Now (a) The time 1, product 1, location 1, text fact new tables created in a data source (CB-TEST-DS) (b) cube opens in BIDS Deploy cube, process cube by adding data in source tables (timel, product 1—–).
Cubes → RC new cube → Next → Generate tables in the data source template Select template (Adventure works enter pries edition) Next → Select measures, Measure group (or) Create Measures, Measure group Next → select dimensions (or) Create dimensions Next ———-
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
I am Ruchitha, working as a content writer for MindMajix technologies. My writings focus on the latest technical software, tutorials, and innovations. I am also into research about AI and Neuromarketing. I am a media post-graduate from BCU – Birmingham, UK. Before, my writings focused on business articles on digital marketing and social media. You can connect with me on LinkedIn.