Categories
OAC ERROR: The data source does not support adding every dimension to the SELECT list.
Summary
After updated OACC to 105.3.0-93 No reports that connect to EPBCS will run.
Content
After updated OACC to 105.3.0-93 No reports that connect to EPBCS will run. Any ideas?
Version
105.3.0-93
Answers
-
Hello Greg, Facing the exact same issue when pulling FCCS into OAC. OCI instance so can't check instance but EPM 19.10.
Did you resolve the issue or change the report layout?
Thanks
0 -
The only way around this for me was to leave out a dimension from both the grid and filter. For me this is not a viable solution since I report off of an Essbase cube and need to be able to filter on every dimension. I spoke to the Oracle Dev guys and they say that they are working on a patch fix which will become available soon. I'm not sure what "soon" means since I've had a ticket open with them for over 5 months now.
0 -
Anyone has a fix for this issue?
0 -
Not a fix but a workaround. If you add a "fake" (empty) dimension to the cube outline and just never include that in the analyses it will work.
0 -
@Christian Berg Would that fake dimension be setup within EPM or OAC? We've started seeing this issue on an EPM connection in OAC that had been working without issue up to now.
0 -
You need that fake dim in the EPM cube outline. If your cube has 12 dimensions, add a 13th one to the outlined that never gets included in the query. This way you can query your "real" dimensions from 1 to 12 without running into this issue.
A hack, granted, but for a solution you need an SR and a product defect.
0
