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
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
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
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:
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百科
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:
Having a hard time doing this simple thing: return 0 instead of \"null\" SELEC开发者_C百科T { [Measures].[Count]
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
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:
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.