Will try that... Sorry I know that must be the answer, the thing is I'm good with the RPD but I almost never use OBIEE Answers itself heheh. Thanks!

where do you declare Presentation Variables? isnt that specifically for dashboardS?

I don't know if this what you are asking, let me know.

SOLVED: Folder for customMessages is custommessages according to this document: OBIEE 12c: Act As Not Functioning: This Functionality Has Not Been Enabled By Your Administrator (Doc ID 2118194.1)

Thank you so much Sir... One day I will learn the mysteries of reality, God existence or not, secrets of the universe and finally why Oracle does whatever it does.

Is that why OBIEE 12c scrapped Opaque Views? wait, it still has opaque views! Wonder when are they gonna rid of them, so useless... the purpose of my reply, although is not the ideal solution, is to expand the conversation, to show the many possibilities of doing something, and at least to acknowledge a "defect" that…

how about you just create an opaque view with whatever select statement you need? selec NVL(columnname,*) from dim a inner join fact f outer join dim b

Ok, found the newest datamodel.cmd However the upload command throws this error: "DESC_CODE_SERVER_EXCEPTION" and the download command simply gives me Services Instance Key ssi does not exists. Crazy.

I tried but I get the same message, that I'm not using it correctly> D: \OracleBI12212\Middleware\Oracle_Home_12212\bi\modules\oracle.bi.commandline.tools\scripts\datamodel.cmd uploadrpd -I repository.rpd -SI ssi -U weblogic -P somepassword -D now, is the script path correct? D:…

oh, yes, it is ssi, but I used the example that the documentation is providing just for the sake of filling out the info, I actually executed the command with ssi

Thanks for the answer... I found a new datamodel.sh but its usage seems to be different, is not allowing me to use the above command and I can't find any documentation for this. D: \OracleBI12212\Middleware\Oracle_Home_12212\bi\modules\oracle.bi.commandline.tools\scripts\datamodel.cmd uploadrpd -I repository.rpd -SI bi -U…

Go to the EM and check the log from there... this happens to me a lot and I just need to reload the RPD due to corruption... I do a lot of Online mode editing of the RPD and it makes the BI Server unable to restart so what I end up doing is loading the SampleAppLite.bar RPD and then restarting the server and then the BI…