on 03-08-2017 5:06 PM
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.
BPC embedded?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I meant that I run them and, nor compresion neither "zero removal" were happened. But today I did some modificaciones on the process chain for the Lite optimization package base on some advices i found in this foro, and now it works but I got the same error when I try to access de cube.
Basically, after including the "zero removal" option on the process chain, when I run Lite optimization, the package status is Abort, and when I run a report, I got the same error as when I tried to access the cube throught BW.
-------------------------------
code: UJO_READ_EXCEPTION_000 severity: error description: MDX statement error:"SQL Error: 208" log id: 051MibWC7jU2WQvgcnb0nW DATAVALUE:SQL Error: 208
-------------------------------
I found out how to get the model funtional again (adding or removing a property on one of the model dimensions) and I can see the optimizations worked now.
Thanks for your help.
Sure, I followed the steps described here:
https://blogs.sap.com/2010/06/10/optimization-with-zero-elimination/
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.