1
Is it possible to use SSAS Tabular models as sources for other Pyramid models?
Can SSAS Tabular models be used in the Data Modeler as a data source?
1 reply
-
The quick answer is yes. However, you will not see SSAS as one of the source node types. Any existing model can be used as a source for another model via a node called Pyramid. The way it works is to create a Discover report using the SSAS model as the source and then use that report as input to the new model. The trick is to include all the necessary fields that you want combined to filter the data.
Here is an example:
- I created a report from an SSAS model.
- I then created a model that uses the report as a source.
- I combined the data with an Excel file that contains Budget info.
- Finally, I create a new report from the new model.
- I created a report from an SSAS model.