ssas
SSAS - Changing Target Server
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-[详细]
2023-03-13 00:36 分类:问答Merging two tuples in the same hierarchy into one (in MDX WITH SET command)
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[详细]
2023-03-12 05:28 分类:问答MDX on multiple hierarchical dimensions
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[详细]
2023-03-11 20:13 分类:问答MDX measure as on date
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[详细]
2023-03-11 15:54 分类:问答Cannot connect to SQL Server Analysis Services even though it seems to be running
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[详细]
2023-03-11 11:12 分类:问答Microsoft Decision Trees: support cases for a specific node
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[详细]
2023-03-11 06:59 分类:问答individual day calculations ,in MDX, with Start and End date in fact table
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).[详细]
2023-03-10 21:14 分类:问答OLAP Error while Processing
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:[详细]
2023-03-10 20:36 分类:问答List dimension members with MDX query
Is there a way to list dimension members without fetching default Me开发者_高级运维asure for each member?You could SELECT nothing on the opposite axis:[详细]
2023-03-10 19:52 分类:问答A shorter way of specifying a set in MDX
Is there a brief开发者_如何学JAVAer way of specifying a set in MDX? I know I can do something like :[详细]
2023-03-09 22:15 分类:问答