Hello guys!<br />I have a problem using AS2005 Data Source Views using more than one Data Source. <br />The first Data Source is a SQL Server...
If I'm not wrong, the page in the link refers to the number of cubes in a virtual cube (in the MOC course book 64, in the link 255, strangely), not...
At the Analysis Services 2000 MOC, they teached me there is no limit to the number of Cubes per database (unlimited), but only to the cubes per...
Frankly speaking, I don't know a sharp method. However, I have an 8.0.760.0 version of AS2000, and this is a Developer Edition, whilst on another...
Hi, Maybe you've got the Analysis Services 2000 Developer Edition instead of the Analysis Services 2000 Enterprise Edition? In fact the Wizard for...
Hi everybody! I see that DrillThrough on the Fact Table is not working in the February CTP version of AS2005, and the "help" confirms it. Does...
In AS 2000, should be this way: WITH MEMBER Measures.NullColumn AS 'Null' SELECT {Measures.NullColumn} ON COLUMNS, {[School].[All],...
Microsoft Offical Course book, named "Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000" is very good. Don't know if it can be...
Well, finally I have discovered from the help of MSAS2005 Feb05 CTP that the custom level formulas (custom rollup formulas) don't exist no more, but...
If you have several levels/attributes for a dimension (like month, week, and so on), you can set the order property in the "Advanced properties" for...
If you have, for instance, for the month attribute: Key | Name 01 | January 02 | February 03 |March ... Of course you should order by key
Has the Month attribute both a key and a name, different from key? Have you set the Order property of the attribute on the key?
Maybe you should better clarify how your dimension is built and how you would like to sort...
I agree with you, there isn't much information on the calculations of AS2005 anywhere.. When I create the customRollupColumn, sometimes there are...
I've just done a lot of tests, by comparing 2000 and 2005 MSAS behaviour.<br />Actually, it seems that the <i>"customRollupColumn"</i> in 2005, is...
Thanks again. You say: "To apply a single MDX expression to all members of an attribute, create a named calculation on the dimension table that...
I suggest you to buy: "Mdx solutions", George Spofford - Wiley. I find it very complete and reliable! Bye.
Thank you very much for your kind reply. Actually I don't understand why should I fill in a whole column to set up the rollup of an attribute. In AS...
Please, try this: AVG(LastPeriods (3, [Time].CurrentMember.PrevMember), [Measures].[NetSales]) It should work... Bye, Vania
Hi all,<br />I'm new to the Forum.<br />Does anyone knows how to realize the "custom rollup formula" in Analysis Services 2005? It seems different...
Separate names with a comma.
