Steve,

I agree that a Parent/Child dimension would work the best in this case. I too work with lots of ragged hierarchies, many of which are still in MSAS 2000....

I think the basic concept that you are missing is that the way you are populating your relational table needs to change. If you do not place nulls between...

Idris Ogueboule (6/22/2009)

---

The number of actual levels is unknow when the dimension is processed. we only know that there are 6 levels at the most. What I am trying to...

Idris Ogueboule (6/22/2009)

---

I am faced with the same problem. I created a hierarchy where sometimes the value of some levels in null ie:

Cust->AcctLvl1->AcctLvl2->AcctLvl3->AcctNum

Cust->AcctLvl1->AcctLvl2->------>AcctNum

I set HideMemberIf to NoName but no luck....

Glad you found a solution. Sorry if my solution didn't make much sense.

Essentially, when building the dimension, you cannot have empty cells between a level and the account number....

Sorry... I got xp_sendmail mixed up with xpsmtp (http://www.sqldev.net/xp/xpsmtp.htm). I use xpsmtp because you do not need a mapi client installed on the SQL Box. Much...

Simply restore your last good backup to a new temporary database on the server. Then script the table from temp db making sure to include indexes, etc.

Once the table...

SQL Mail requires that Outlook be installed and configured on the server to send mail. A mail profile must be setup with connection information to your Exchange server.

xp_sendmail does...

Just found this... there is a HotFix rollup for Analysis Services 2000 which should be applied after SP4 is installed: http://support.microsoft.com/kb/907323/en-us

 

It's common for the cube to exceed the estimated number of rows.  If you edit the cube you will see a rowcount in the properties for the cube.  You can...

There were a lot of major issues fixed by all of the service packs that you are missing.  I really do not think there is not a temporary fix that...

Are running SQL 2000?  If so, you need to upgrade to SP4.

Your post should be in the Analysis Services Section, but...

I've seen this error before, and it seems to be related to available RAM on the server.  How much memory is...

What kind of job is running the cube?  Did you schedule a DTS Package with an Analysis Services Processing Task?  If so, what method are you using to process the...

All you have to do then is this:

 

WITH MEMBER [Sku].[ Grand Total] AS '([Sku].[Brand].&[15], [Measures].[Stock Cost])', SOLVE_ORDER = 1000

SELECT { [Measures].[Stock Cost] } ON COLUMNS ,

NON EMPTY { {...