MDX查询结果到Netezza表

问题描述

大家好，

我不是来自SSAS背景。我们正在尝试自动化一个流程，我们当前正在切换连接到SSAS多维数据集的Excel工作表上的多个筛选器，并与Netezza表上的数据进行可视化比较。基本上，我们使用Netezza表上的数据验证
多维数据集的结果。

作为其中的一部分，我们创建了MDX查询以根据我们需要的特定过滤器提取数据从立方体。我们可以通过bash或Informatica（只有我们拥有的ETL工具）自动调用/执行这些MDX查询并将结果保存到csv或表吗？请
忽略我对SQL Server技术的零知识，并感谢这方面的任何指导。

谢谢！

解决方案

Hi all,

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!

解决方案

这篇关于MDX查询结果到Netezza表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！