admin管理员组

文章数量:1434949

I have an OLAP Cube created by relating about 40 tables(5 facts and 35 dimensions).

The question im interested in is if I query (select count(*) from tableA) to the SQL Server, should the result differ from the result of the equivalent query on the PowerBI server queried on the OLAP Cube?

For example :

Table A [Acol1, Acol2, Acol3] Table B [Bcol1, Bcol2, Bcol3] Table C [Ccol1, Ccol2, Ccol3] Table D [Dcol1, Dcol2, Dcol3]

And the architecture looks like:

A<->B<->C->D... AA<->B<->E...

And so on.

The query on the SQL Server: select count(*) from tableA

The query on the SQL Server: MDXFormat(select count(*) from tableA) (I do not know how to write MDX sadly)

select count(*) from tableA The output : 950

MDXFormat(select count(*) from tableA) The output : 952

I expected them to be the same, but there is a slight difference for some reason. I think OLAP Cube and the SQL Server do not have the same data. What I expect from OLAP Cube is to include only the related tables to the query, but I'm not sure if that's the case or not.

本文标签： sql serverDo OLAP Cube architecture include the unrequired tables to the queriesStack Overflow

版权声明：本文标题：sql server - Do OLAP Cube architecture include the unrequired tables to the queries? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1745636115a2667567.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。