ah ok, you are using a request variable. And your question is why the Second Prompt does not show any values in the list of values for 2018? Well, if it's based on 2018 and you say there are no results yet for 2018, then why do you expect values here?

You can save the prompt values you selected by selecting Save Current Customization in the page options menu. you can apply it with Apply Saved Customization and/or set it as default with the Edit Saved Customizations Option.

Well, you cannot assign values to Session variables using a prompt, for that you need a Presentation variable. Other then that I do not really understand what you are trying to accomplish. Please post some example results and expected results.

My question still is: why would you use Presentation variables when you can use Dashboard prompts that will carry over values? Sure, this will work, however I'm not certain it is the best or easiest way to achieve the requirement.

Not sure what you mean by not exposing individual tabs to user? You can hide dashboard pages if that is what you want. They will become visible after you navigate there through an action link. If you create an action link to navigate to other content (Dashboard page, analysis,..) then Dashboard prompts values will be taken…

Not sure if I understand your question correctly, but why you are using presentation variables here? Did you try to use Dashboard prompts with the scope set to Dashboard? That will apply the prompt to all pages in your dashboard. Just make sure all reports on both pages have an "Is Prompted" filter on Country.

Either you are very bad at explaining problems or comprehending then solutions suggested. Or both..

You might also want to check if your Linux/Unix guys make file system backups EDIT: If by "which Backup" you mean you don't download the RPD on a regular basis yourself that is ...

That doesn't seem right at all actually. As soon as you drag a column from Customer Product in your analysis your figures will explode as (i assume) customers have more than one product. What are you trying to achieve, by this i mean what is your functional requirement. -Are you trying to create a analysis of sales on…

Well, that's one of the things that usage tracking does as Joel already said. Really wondering what exactly you want to achieve?

You can get that (if you have the proper privileges) via Administration --> Manage Sessions. Select the action that you want to see the physical SQL of. You can see in the information column which item has generated the sql. Down below in the log will be the physical SQL statement(s). An other way to get the same is to…

So were you talking about roleplaying dimensions as Christian suggested? And if so you solved this by creating aliases hopefully. Please update so that others may benefit as well.

Can you please elaborate on your problem? Hard to give a meaningful answer without any details.

And pray the client won't have any questions...

I'm pretty sure you will not impress your client with a demonstration that you didn't even make or do yourself.

Do you mean to schedule validaterpd? And can you explain what exactly you are trying to achieve by doing that?

That's not out-of-the-box functionality for OBIEE, no. The best approach is to use BI Publisher which has bursting functionality available. If you must, this blog describes a way to do bursting with agents: Hyperion, EPM, OBIEE and other stuff. I wouldn't advice this because I do not think this is a very stable solution…

I would advise you to do some hands-on tutorials provided by oracle if you want to learn OBIEE, instead of looking to videos. http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/obiee11g-453435.html Oracle BI EE 11g If that even is what you are asking.

@chillychin Were the answers provided solve your problem or were they helpful to you? Please mark the answers as such so it may others as well.

Which version are you using? If you are using an earlier 12c version you should upgrade to the latest version. Please check this post at rittmanmead: https://www.rittmanmead.com/blog/2016/02/obiee-12c-repository-password-corruption-issue/ The comments have some good information as well Edit: You probably still need to…