In Business Intelligence Developer Studio, I\'m wondering why one would want to create a report model from an OLAP cube.开发者_如何转开发
I have a user asking me to list the dimensions and dimension attributes of our SSAS cube. I susspect I could generate this via AMO, but I\'m开发者_C百科 wondering if there\'s an MDX query or SSMS op
I wanted to use dimension properties on columns. So, in the mdx que开发者_开发知识库ry, I dragged in those properties from the dimension \"member properties\". But, for some reason, the values for tho
In MS Excel 2007 on PC you can connect to a MS Analysis Servic开发者_开发技巧es Cube via Excel. I can\'t see how to do the same on Mac using Excel 2008 there.
I have a hierarchy, like an ProductDimension hierarchy.Currently, I query this table using the Nested Sets methodology.I write the usual star-schema joins to get a time-series report of groups of Prod
I\'m currently researching SQL Server 2008 as a business intelligence solution, and currently looking at Analysis Services (and I\'m pretty new to business intelligence as a whole...)
In my Analysis Service OLAP Cube I would like to exclude fa开发者_如何学编程cts having unrelated dimensions, which during processing produce errors. I would also like to avoid making Named Queries in
Problem: I need to retrieve the language of a given cell from the cube. The cell is defined by code-generated MDX, which can have an arbitrary level of indirection as far as calculated members and set
Is there a way to only deploy cube schema, but without processing the cube. It seems in Visual Studio, when yo deploy a cube, by default, it is \"Deploy and Process\".
To all excuse my ignorance, but I\'m ne开发者_如何学Gow to MDXbelow is the query I\'m trying to run
加载中,请稍侯......