When browsing the cube in Microsoft SQL Server Analysis Services 2005, I would like to peek at the MDX (supposedly) queries generated by client access tools such as Excel. Is there a tool or method that enables me to do just that? I'm really looking for something like Oracle's v$sessions -- I know about sp_who and sp_who2 for the relati...
Background: I'm writing a data provider that SSAS will use to get data from a third-party system. I wrote a tool that will build cubes, dimensions, measure groups and measures based on the configuration of the third-party system using AMO. Now, in the Cube Browser, I am able to pull the members of the dimensions, however, measure data ...
I'm currently trying to model a ragged hierarchy in SSAS and I'm stuck. First, I was trying to model it like so: ItemKey,Level0Key,Level1Key,Level2Key Item1,Lvl0-1,Lvl1-1,Lvl2-1 Item2,Lvl0-1,Lvl1-1,Lvl2-1 Item3,Lvl0-1,Lvl1-1,Lvl2-2 **Item4,Lvl0-1, , ** Where the last line in this example had blanks for the "missing" levels. Here, RO...
I have cube in Microsoft Analysis Services with several dimensionsions and measures. When I(in cube browser, or through pivot tables in excel) try to drag dimension's attribute to grid with no measures added the following happens: if there were unknown member, then only it is displayed. Other rows from dimension are not displayed. if ...