cancel
Showing results for 
Search instead for 
Did you mean: 

Cube partition question

Former Member
0 Kudos

Dear All,

I have tried to partition a cube in my dev system (deleted the data first) on 0CALMONTH. When I try to activate the cube, it is failing (telling me it cannot activate the cube as 0CALMONTH is included in other cubes which have data)

I try to rollback my change (remove the parittion) - and guess what - I get the same errors --> I cannot activate my cube anymore!!!

So, I have 2 questions:

1 - I have understood that the cube can be partitioned if it has no data, but it should not be linked to other cubes

2 - How can I rollback my change?

Any help highly appreciated

Thanks

Ioan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Ioan

Haven't come across this specific problem but might be worth using RSRV tool to have a look for possible inconsistencies in your cube - have found it useful for a number of different errors that can occur when implementing structural changes. It will report on an errors found and in most cases you can then run a repair.

former_member188975
Active Contributor
0 Kudos

Hi Ioan,

Is there an error message number?

Former Member
0 Kudos

Not really. I get a R7757 (not all objects could be activated) and then a long list of Oracle logs (warnings and errors). The errors are ' ... table XXXX cannot be activated ...' (I will not include it here, it is too long)

I didn't find anything on OSS, I already looked

Thanks

Ioan