Hello Everyone,

I am trying to programmatically add an existing dimension to a cube using DSO.

Set dsoCubeDim = dsoCube.Dimensions.AddNew("Sponsor")
dsoCube.Update
dsoCube.Process processFull

I am getting the following runtime error when the Process method is executed:

Run-time error -2147221425 (8004004f)
A table was detected in the schema that is not joined to any
other table

If I go to the Analysis Manager and open the cube in the editor, there are no
apparently disconnected tables...

If I exit from the editor without saving, the cube will subsequently fail to
process and indicate that an un-joined table exists.

If I save the cube when I exit from the editor, a Count Members popup window
appears indicating that "One or more levels have a count of zero.". The cube
will then Process without any problems.

Clearly there is something that needs to happen after cube is updated and
before the cube is processed.

Can anyone point me in the right direction?

Bob Segrest, PMP
BSegE LLC
(540) 937-5875
http://www.BSegE.com

Based on some testing with the FoodMart Budget cube, the JoinClause
property of a cube needs to be augmented with a condition for the added
dimension table, even if that table already appears in the Cube Editor
schema.


The steps were:

- Remove Category dimension and save Budget cube.
- Category dimension table still appears in the schema.
- Adding Category dimension back ends in process error.


It works after modifying the Join Clause in DSO script:

MsgBox "Cube Old Join Clause: " & dsoCube.JoinClause

Set dsoCubeDim = dsoCube.Dimensions.AddNew("Category")
dsoCube.JoinClause = dsoCube.JoinClause & " AND " _
& "(""expense_fact"".""category_id"" = " _
& """category"".""category_id"")"

dsoCube.Update
MsgBox "Cube New Join Clause: " & dsoCube.JoinClause
dsoCube.Process processFull

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!