Hi, When you define a measure on the RPD you NEED to set an aggregation level. this usually can't be overwritten. However e.g. if in your criteria tab you have year and month and a metric Qty aggregated by default as SUM. If you then apply a MAX function as aggregation in criteria tab then the result value for year will be…

+ 1 to @Gianni Ceresa The usage of presentation variables in prompts works only if the selectors are in different prompts objects. e.g. if you want to influence Product Group by the Brand selected you'll have to put Brand in a separate prompt. But...You have the "limit values by" feature by default... why don't you use…

Hi, There is no such adaptive feature in OBIEE by default.

I would avoid doing it with a VIEW in the DB but rater importing all 7 and use OBIEE's fragmentation if there is a way of telling to OBIEE which partition of data is within each table. The view option will always query all 7 sources while using fragmentation you'll hit only the fragment with the data you need if you…

You could try looking in the analysis XML, but it's up to you if you then break the analysis

What error do you see in obis1-diagnostic.log when you try to login? can you also check obips1 sawlog ?

Hi, I would check BIServer log file $FMW_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqserver.log

Also this doesn't tell much. Can you try to restart the component and check the logs while it's restarting?

Hi, Is the RPD consistent? No errors? can you first just upload only the RPD (laving the catalog out) and then check if the system is working?

Did you try restarting the whole stack? is bi_server1 (the managed server) up& running? can you connect to the RPD in online mode?

Is this /oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/K.rpd a valid RPD?

Hi, Is that the only error? what happens if you retry the red upload?

Any error in obis1-diagnostic.log?

As suggested by @Gianni Ceresa fixing your data model should be the route to follow. You can define casting or special joins in the model but performances will be really poor.

Not casting as VARCHAR? You should be able to set the date format in NQSConfig.INI file.

Have you considered doing what the error is saying? An exception occurred during execution, please check server logs. obis1-diagnostic.log biserver1.log or other server logs?

Unfortunately there is no Out of the box solution for it. You'll need to play with CSS.

you can simply re-execute the steps as written in https://www.peakindicators.com/blog/enabling-r-in-oracle-bi-12c check no errors arise during the installation

IIRC=If I remember correctly.... You need to install R and all the required packages... the message clearly states Error(s): Error in doTryCatch(return(expr), name, parentenv, handler): could not find function "read.csv" (HY000), So it can't possibly find the related package

Have you installed R and related packages in the server? IIRC those were additional steps you need to do on top of a basic installation