Are you running this on your OBIEE server? Try adding -SI ssi to your parameters of the datamodel.cmd command where ssi is your Service Instance name Also, your BI server doesn't look healthy from the screenshot you provided. what do the log files show about this? Could you also try using the datamodel.cmd file in this…

You'll need to help us here if you want us to help you. You'll need to provide a bit more information - some screenshots of the code would also be of help. Have you correctly set the EVALUATE_SUPPORT_LEVEL parameter in your NQSconfig.ini file?

Your best and safest option would be to start from scratch

To be clear, my reply assumed (should have been clear of that in retrospect) that the OP had a well formed dimensional model with facts and dimensions in the BMM layer. You're right, if there isn't a proper model then the OP has a bigger issue...

Your rpd needs to be modified as the measures haven't been defined as such and you're comparing strings instead of numbers (note the different icon for measures below). Add aggregations to your measures in the BMM layer to the measures and it should work.

Have you tried other browsers? Try clearing your browser cache as well. Which browser are you using by the way?

You're using the wrong approach. @Gianni Ceresa has blogged on the right ways to do this: https://gianniceresa.com/2017/02/obiee-12c-custom-style-using-shared-folder/ https://gianniceresa.com/2016/12/obiee-12c-custom-style-ear-file/

You can do this via the exportserviceinstance ,listconnectionpool, importserviveinstance & updateconnectionpool commands. Robin's blog describes the process in detail: https://www.rittmanmead.com/blog/2016/12/source-control-and-automated-code-deployment-options-for-obiee/

Why don't you simply exclude them from the prompt?

Your best bet is to speak directly with Oracle via an SR. Doesn't make much sense why lower versions of 11.1.1.9 are listed and not the version that you're on.

in that case, some screenshots may be useful so we can see what you're actually doing in the design view of the analysis

In addition to what @Christian Berg has mentioned above, you'll also need to provide some more information about your dashboard (assuming that this is from one). Are your analyses in separate sections?

You can Protect the Filter. check the Protect Filter checkbox and this will ensure it doesn't get overridden by a dashboard prompt

What version of DB2 and OBIEe are you using? Also, what OS are you using?

Looks like an Excel issue and how it is interpreting your "date". OBIEE is doing what it has to but and it appears to be exporting it correctly as "17-Nov".

I think you mentioned that there were some invalid data entries in your time dimension. I was just suggesting that you clean these up and then retest in order to determine if this is the culprit of your issue.

Exactly what @Gianni Ceresa said. You'll need to provide a bit more information. query log extracts, screenshots, OBIEE versions. How is the dashboard prompt getting its default value etc etc

I think you should start with tidying up your time dimension. That should be the 1st step to rule out the data in there that needs to be excluded.

It could be one of many things but most likely, it seems to be something with your model I'm guessing. The screenshot you supplied doesn't show the incorrect grand total. Additionally, could you supply a snapshot of the query log for this report?

Can you ping the email server from your OBIEE server? That would be a good place to start - as everyone else has said, this doesn't look like an OBIEE issue.