ssas

相关标签：javascript jquery android 多少钱 iPhone

Purpose and effect of SSAS hierarchies?

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[详细]

2023-03-31 09:11 分类：问答
Multiplying Quantity * Price in Calculated Member

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.[详细]

2023-03-30 01:14 分类：问答
"Duplicate attribute key" error when attribute is not a key

I am getting the following er开发者_如何转开发ror when processing a Dimension: Errors in the OLAP storage engine: A duplicate attribute key has been[详细]

2023-03-29 08:41 分类：问答
How to filter a scorecard using the MDX filter expression programmatically?

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[详细]

2023-03-28 13:35 分类：问答
Why do I get error if I do not manually process cube dimensions first?

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[详细]

2023-03-28 05:50 分类：问答
Percentage Calculation on MDX

Im new to MDX Query and I\'m trying to add a percentage on attended percentage in each row.The following code :[详细]

2023-03-27 06:30 分类：问答
Update/Insert sql table from SSAS cube

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[详细]

2023-03-24 07:13 分类：问答
WCF webservices access to Analysis Services (SSAS)

I have WCF WebService which is accessing cube data using AdomdConnection. Service is hosted inside Sharepoint Server 2010.[详细]

2023-03-24 06:49 分类：问答
Cross-domain access to SSAS

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[详细]

2023-03-23 19:49 分类：问答
Summing up multiple MDX queries in SSAS

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)[详细]

2023-03-23 04:44 分类：问答