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!