CODEWITHSUNDEEP
ssasmdxmdx-querymdxstudiomdxclient
user9254573
user9254573

Reputation: 1

Saving MDX query results to Table or csv file

I am not from SSAS background. We are trying to automate a process where we are currently switching multiple filters on excel sheets that are connected to SSAS cubes and do a visual comparison against the data on a Netezza table. Basically, we are validating the results of cubes with the data on Netezza table.

As part of this, we created MDX queries to pull data based on specific filters that we need from cubes. Can we automatically call/execute these MDX queries via bash or Informatica (only ETL tool that we have) and save the results to a csv or a table? Please ignore my zero knowledge SQL Server technologies and appreciate any guidance in this regards.

Thank you!

Upvotes: 0

Views: 1181

Answers (0)

Related Questions