I am new to analysis services and data cubes.I inherited someone else\'s project, and I am using BIDS 2005.The company I work for recen开发者_C百科tly relocated my analysis database to another server-
The following MDX query returns measure X on 3 tuples: 2001, 2002-1 and 2002-2. What I am trying 开发者_Go百科to do is merging 2002-1 and 2002-2 into one tuple and have the measure X for 2001 and 2002
2 hierarchical dimensions (for location and time) are defined on a cube. My question is about possibility of writing a single MDX query for retrieving following structure. I mean 开发者_运维百科writin
I need a help in MDX My product data(ProductId and Launch date) is like this... P14/1/2011 P2 5/5/2011 P3 3/6/2011
I just ran an \"update edition\" to update from SQL Server 2008 R2 Express to Enterprise. I first ran the update edition process, and then separately added the Analaysis Services component. All these
I\'m using Microsoft Deci开发者_JAVA技巧sion Trees in Microsoft Analysis Services Data Mining, and need to show the historical data (the support cases from the training data used to train the decision
I have a ssas cube with the fact table containing: FactID Status StartDate EndDate the dates are linked to a date dimension (status to the status dimension).
I am new to OLAP, and figured out how to make a cube and process it. However, when i play with it too much, i eventually come up against this error:
Is there a way to list dimension members without fetching default Me开发者_高级运维asure for each member?You could SELECT nothing on the opposite axis:
Is there a brief开发者_如何学JAVAer way of specifying a set in MDX? I know I can do something like :
加载中,请稍侯......