如何使用C＃.net从多维数据集中检索数据 [英] How to retrive data from cube using C#.net

问题描述

i想要从立方体中检索数据，在我的立方体中有数十万的数据，但我想只追回10行，对于10行我有独特之处id，如何传递唯一的id并且只检索特定的10个人数据

就像sql server在运算符中的使用方式一样，在cube中可以指导我或者发送片段

解决方案

我们希望看到那些在海德拉巴工作的员工。记住emp和dept在deptno上加入，city列在dept表中。假设部门所在的位置，员工在该城市工作。

 选择 * 来自 \\ temp 其中 deptno  （选择 deptno 来自 dept 其中 city = '  HYD'）; 

请在此处阅读更多内容： http：//www.oracle-dba-online .com / sql / group_by_sub_queries.htm [ ^ ]

Hi,

i want to retrive data from cube,in my cube have lakhs of data but i want to retrive 10 rows only , for 10 rows i have unique id , how to pass the unique ids and retrive the particular 10 persons data only
like how sql server using in operator, same as in cube can u guide me or send snippets

解决方案

We want to see those employees who are working in Hyderabad. Remember emp and dept are joined on deptno and city column is in the dept table. Assuming that wherever the department is located the employee is working in that city.

Select * from emp where deptno in (select deptno from dept where city='HYD');

Please read more here : http://www.oracle-dba-online.com/sql/group_by_sub_queries.htm[^]

这篇关于如何使用C＃.net从多维数据集中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！