ssas

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

Why does Order ignore subselect?

I\'ve run into some confusing behavior in Analysis Services 2005 (and 2008 R2) and would appreciate it if someone could explain why this is happening. For the sake of this question, I\'ve reproduced t[详细]

2023-03-16 13:47 分类：问答
SSAS modify server time dimension

I have a cube wich has the tipical server time dimes开发者_如何学Cion (it\'s stored in the OLAP server, not on normal SQL server)... It has some members like month, year, 10 days,... but I want to add[详细]

2023-03-16 02:00 分类：问答
Access data cube generated by Microsoft MSSQL BI

I am working on a project where I am hoping to use Microsoft MSSQL Business Intelligence to create data cubes, then access the processed data like browsing them in the BI studio, except the access is[详细]

2023-03-16 00:56 分类：问答
Conditional records count with MDX, SQL Server BI

This may be a simple MDX question but I\'ve spent 2 days without any luck. I have a simple fact table with the following columns:[详细]

2023-03-15 16:14 分类：问答
SSAS Compiling Data Before Processing Into Cube

Working on my first SSAS project from scratch and hoping for some guidance. I have seen different approaches to bringing data into a cube and wondering which is the preferred if any.开发者_C百科[详细]

2023-03-15 15:31 分类：问答
SSAS OLAP MDX and relationships

I new to OLAP, and still not sure how to create a relationship between 2 or more entities. I am basing my cube on views. For simplicity sake let\'s call them like this:[详细]

2023-03-14 21:18 分类：问答
MDX Query - 0 if Empty

Having a hard time doing this simple thing: return 0 instead of \"null\" SELEC开发者_C百科T { [Measures].[Count][详细]

2023-03-13 18:34 分类：问答
SSAS - Data Cube Hierarchy not visible in Excel

Initial Request: Create hierarchies over customer names and product descriptions. Problem:I created several similar hierarchies and the product description hierarchy is not visible in Excel[详细]

2023-03-13 12:16 分类：问答
How can I determine whether dimensions are related?

I am developing a query builder application that generates MDX and trying to get customer counts from a cube using the following, which works just fine:[详细]

2023-03-13 08:46 分类：问答
SSAS-like manipulation of data in excel, without SSAS

I have provided users with a view of a large data set through Sql Server Analysis Services, and they find it very easy and intuitive to manipulate.[详细]

2023-03-13 06:28 分类：问答