Skip to Content
avatar image
Former Member

Invalid Object name after collapse (compress) the cube

Hi experts,

I'm working with BPC on BW7.5. After compresing one of my cubes, when I try to Display Data I got the following error:

Invalid Object name: /B28/XXXXXXX
SQL Error: 208

Seems the compresion is changen some table name and after that, the cube is not longer usefull.

Any thoughts?
Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Number of requests you do not want to collapse = 0

    For clarifing,

    1. First, I found out the Lite and Full optimizations were doing nothing to my models. I know this after checking the data on the cube as well as checking the requests, which were not green flaged.

    2. I use BW trying to collapse the cube: Inforprovider > manage > collape tap. Eventhought it works (I can see the requests all flaged green I'm not able to access to the cube data and I got the error.

    2. Back in BPC, I did the modificaciones on the process chain base on the link i attached before. The I try to access the model from BPC or the cube from BW I got the error again and the cube/model become unavailable. When I solved the error by "shaking the model" (creating a new property on a dimension) I can see the optimization has been done.

    Basically the problem it is not with the optmization itself, but because of the optimization, something it the model/cube is not-adjusted.

  • "First, I found out the Lite and Full optimizations were doing nothing to my models. I know this after checking the data on the cube as well as checking the requests, which were not green flaged." - by default "Number of requests you do not want to collapse" is 2!

    "I use BW trying to collapse the cube:" - don't do it!

  • Incorrect reason to close answer! No accepted answer!

  • Get RSS Feed

1 Answer

  • Mar 08, 2017 at 05:18 PM

    BPC embedded?

    Add comment
    10|10000 characters needed characters exceeded