The way I have gotten around this is by changing the formula for the prompt. I'll try to explain. If I have 3 dashboard pages that have prompts for 'Customer Number' and I want each of those prompts to act independently in scope, then I do the following: (1) Page1 prompt: (a) I go into the formula for Customer Number in…

As mentioned above, it sounds like you are bypassing the cache to the tables in the RPD & in EM -- which I believe means it will not use the BI SERVER cache -- but your reports are still using the Presentation Server cache. To bypass that here is what I do: To bypass cache in a single report…

I think this would give you exactly what you are looking for. We used it at my last employer and it worked very well. https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis Hopefully this helps!

Very weird. Not sure why I did not see that option when I was working with 12c at my last employer. Oh well...I have the option now, and I'm sure we will have it when we upgrade our current environment up to 12c. I appreciate everyone's input. Thanks for the answers! Chris

Thank you Gianni! That certainly answers my question. I have only marked your reply as 'Helpful' (instead of marking it 'Correct Answer') so as not to totally close my thread -- as I'm still hoping that someone might add some insight on the 2nd question I posed also. My apologies for that, and thanks again! Chris

Thank you!

This is one of those things that is a little hard to explain in a post, but I'll try... For your PREVIOUS_FISCAL_START_DT prompt, go into the Formula and make it something like: CASE WHEN 1=0 then 'ANYTHING' ELSE "Time"."Date" For your CURRENT_FISCAL_START_DT prompt, go into the Formula and make it something like: CASE…

I'm very sorry. I see all of the text in the screenshots are in French. I only speak English You should just be able to put your new dashboard prompt right at the top (or anywhere for that matter) of your dashboard -- just by dragging it from your Catalog pane into your Layout pane.

I'm going to take a guess here and say that you probably built the prompts for each graph within each analysis (by going to the 'Prompts' tab). *My below instructions are assuming that all of your graphs are coming from the same subject area. If they are not then we'll need to be a bit more creative and use variable…

I am certainly no expert on cache and how it works in OBIEE. However, I think it might be worth trying this one thing -- When using the SAPurgeAllCache() command, you could also try this additional step: Go to Administration->Manage Sessions Click 'Close All Cursors' See if that helps.

You can enter the 100 numbers quite easily. Just click on the 'search' feature of your prompt dropdown. Take a look at my screenshots below: (1) (2) (3) You can paste your values in here (no semicolons between values): Hopefully this helps!

As far as I know, you always have to use a semicolon to separate your different values in a dashboard prompt. As I test it right now (just as a sanity check), that is the case. For a 'State' prompt on my dashboard, if I enter: NY,CA I get no rows But if I enter: NY;CA I get rows for New York and California

Possibly try using a 'Choice List' for User Input (instead of 'Text Field'). Be sure to leave the 'Enable user to type values' checkbox checked. This will still allow users to enter values, but will also give the added functionality for users to search/select from a list of values -- and hopefully alleviate your problem.

Certainly the solution(s) given by Gianna Ceresa is the most sound & prudent route to take -- and I certainly do not mean to muddy the waters here... But I just wanted to put this out there (in case it would meed your needs): In our case we wanted to hide some of those things, but only hide them on a few dashboards. In our…

https://docs.oracle.com/cd/E14571_01/bi.1111/e10541/webuicustom.htm#BIESG1382 http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1113/customizing_obiee11g/customizing_obiee11g.htm

If I am not mistaken, I think that every column is an 'attribute' until or unless you specify otherwise. To do that, you go into your fact table & set the aggregation on the column thereby making it a 'measure'.

Could you give each user their own folder in the Distributed Development Folder, and then let each user give permissions to any analyses or subfolders they have in their own folders? Maybe I am over simplifying and not totally understanding the issue.

I must say...it is very weird that the way you are doing it is not working. I tried it on my end and could not get it to work either. To get it to work, I wrote something like this: SELECT "Date"."Date" FROM "Sales-SubjectArea" where "Date"."Date"=current_date The key here was that I added a 'where' clause and it seemed to…

I was able to achieve this in some of my reports by doing the following: Go into the properties of the table and there is only 1 tab (it is called 'Style'). For the 'Data Viewing' category, check the 'Content Paging' radio button. Then be sure to set all of the borders to all of the fields (headers & values) in your report…

I believe there are 2 ways you can achieve this: (1) Just as Gianni Ceresa said -- you can create the count column in your RPD. That way it will show up in your filter view with whatever name you gave the column in the RPD or (2) Instead of using the Filter view, you use a Narrative view. For example... If I have a prompt…