Firstly, I feel comfortable with what a hierarchy is in terms of the concept and how it impacts the design of a DW\'s star schema.I have some dimensions with lots of attributes, and I could create lot
I know MDX is used for much more sophisticated math, so please forgive the simplistic scenario, but this is one of my first Calculated members.
I am getting the following er开发者_如何转开发ror when processing a Dimension: Errors in the OLAP storage engine: A duplicate attribute key has been
I have a scorecard which I would like to filter the data using MDX filter expressions. I have got the MDX filter expression which consists of a filter applied on 2 columns, but I am just missing the l
In an Analysis Services project, after making some changes I go to reprocess the cube and get \"attribute key not found\" errors almost every time.The solution has been to process the dimensions first
Im new to MDX Query and I\'m trying to add a percentage on attended percentage in each row.The following code :
Is it possible, preferably using tsql or MDX, to read data from cube and use it开发者_开发知识库 to update or add records in a sql table?OPENQUERY can do this
I have WCF WebService which is accessing cube data using AdomdConnection. Service is hosted inside Sharepoint Server 2010.
Our IT department has set up a sandbox server for developers on a separate network.It is running SQL Server 2008 R2, and Sharepoint Enterprise 2010 with PowerPivot, which requires Analysis Services (S
i need to SUM the results of multiple queries. the challenge that i have is that each query has defined members (to calculate a date range)
加载中,请稍侯......