This content has been marked as final. Show 3 replies
What version of 11g are you using? Any OLAP patches installed? I do not see that error message in our source code.1 person found this helpful
I'd like to see where that message is coming from. Could you set event "36891 trace name errorstack" either at the system level or session level and reproduce the error.
Please open an SR with Support and provide the call stack from the trace file. We would also need to see the definition of bg_SILUETT_GF_table to start: from the OLAP DML, "describe bg_SILUETT_GF_table"
Thanks a lot Steve for this information.
DBA is going to raise SR for this issue with Oracle Support.
select * from v$version
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
PL/SQL Release 22.214.171.124.0 - Production
CORE 126.96.36.199.0 Production
TNS for IBM/AIX RISC System/6000: Version 188.8.131.52.0 - Production
NLSRTL Version 184.108.40.206.0 - Production
ORA-36819: SILUETT_GF!SHSH4.HIERDIM cannot be used in a LIMITMAP HIERARCHY clause.
I will keep you updated.
Declare HIREDIM as formula.
Change LIMITMAP to use 'MEASURE' instead of 'ATTRIBUTE'