I\'ve got a cube set up with a number of partitions - one for each year of data in my fact table. I\'d like to process partitions on an indi开发者_C百科vidual basis. Is this possible? If so, how do I
Is there a way to trace the actual MDX generated by querying a Cube in Excel, and get the actual MDX used ?
I have an ASP.NET application which needs to connect to Analysis Services database. All components are on the same machine:
I\'m looking to build a web application using an SSAS cube as the data platform. As such, I would like开发者_StackOverflow to list the dimensions in drop down lists. For example, I have a dimension c
I\'ve got the following question. I have 3 dimensions: Dim1 Dim2 Dim3 And a fact table, let\'s say: FACT After processing the cube, I run a query which is to obtain the values filtered by dimension
I have a measure for open balance for a particular account.My users want to be able to have a hierarchy that can bucket dollar balances into som开发者_如何学编程ething like 0-500,500-1000, etc.
I\'m getting two right parentheses for negative nu开发者_高级运维mbers in my cube for all measures.Can\'t figure out how to fix it:
I have a requirement and I am not sure if I should use Analysis services or Reporting services or some other technique.
I have a cube that I built in SSAS for general ledger data.The cube uses 2 fact tables.One for accounts that are \"normal\" dollar based accounts and the other is for unit / statistical accounts - acc
I am using AMO to programmatically generate an OLAP Cube. How can I add translations for the calculated members? (SQL Server 2008)