Dashboard with prompts does not go to cache
all I've been reading on the internet and documentation about caches, makes me think that seeding the cache is only useful for running reports, but not Dashboards. Is this true?
I have seeded the cache with one iBot, and if I run the report iit goes to the caché. But if I use the dashboard which contains the report, it does not go to the cache. Could this be because in the dashboard I have 5 prompts which I'm using in the report?
Does the cache work when the dashboard contains prompts used as filters in the report?
I have seen in the forum and blogs the conditions for a query to go to the cache instead of going to the database, and I follow all the rules. But for example, if I have in a dashboard with prompts, a report with the following columns:
Column A, B, C, D
where C is prompted
and D is prompted
what should be the ibot to execute?
Thanks for the link, but I already checked. Also, it goes to cache when I run the report by itself (from the answers window), but not when launched from the dashboard.
To answer your question, one of the prompts contains month and year, and it's filled from a variable defined in the repository (selec max(month_year) from table). Also, every prompt that we use saves the choice made by the user in a variable (so that we can filter in the report). Could this be the problem? Does cache not work with prompts kept in variables, or prompts that use variables?
In OBIEE 11g, I have a dashboard column prompt with a date column. I use this column in the analysis and have made the column properties (formatting) a system-wide default for that column. When I use the column in a dashboard column prompt, it does n
I want the dashboard date prompt value to be reflected in the date coloumn(Whatever user selects from calendar) and all the filter should operate on this date. Can it be done?? The user entered date in the prompt should be shown as a coloumn in he re
Hi, I want to make Dashboards more efficiently by putting them in the Cache, but they have defined lot of prompts that can take several values. How should I proceed so as the the cache generated contains data required for this dashboards no matter th
Hi, I've created a BI Publisher report using BI Answer as data source. For getting some xml files for building the rtf Template I've set my filter datas to fixed values. I've created my dashboard with my BIP report and a query from BI Answer. All was
Hi all, We have a Dashboard page in that multiple reports is there and one Region prompt is there with the scope of page level , once i gave the filter with that prompt every report is filtered based on that prompt values . but in that reports for a
There are two dashboards 'Chart' and 'Transaction details' . I am trying to link from one report(dashboard called 'Chart') to another dashboard(Transaction details). In first dashboard (screenshot 1) there is a column called 'Day' which is like date.
Hey everyone! I have a dashboard prompt that has two date range selections (created date and book date). I need these to be the same date range - if a user puts a date range in the created date prompt, I'd like it to be the same in the Book Date prom
Hi, I found an interesting (at least for me) case regarding OBIEE Prompts. Earlier: We were using a dimension let’s say : Department in our RPD and hence dashboards. Later due to SCD type2 and other backend problems we had to create a new Table and t
Hi, I had recently migrated from OBIEE 10g to OBIEE 11g. I had found that there are lot of things which were working on OBIEE 10g are not working in OBIEE 11g. For Eg: I have scenario where i have 2 dashboards with different dashboard prompts. - *1st
Hi all, I had a requirement: In my dashboard page , prompts are YEAR , QUARTER , MONTH , PRODUCT NAME , ORDER NAME . Now when i select YEAR = 2010 , then Quarter should display values related to 2010 . If i select Quarter = 2010 Q1 then month should
I have a issue of prompt propagation in a dashboard, that is the various dashboard page prompts use same presentation layer column then the prompts are taking the filter values filters on each other dashboard. Even if I try to change the scope of eac
Hi all, I have to dispay 'TOP' & 'BOTTOM' dynamic value in the dropdown of dashboard prompt how to create a dynamic column value in dropdown of dashboard prompt?I m trying to create it by writing case in show sql result but not getting correctly acco
Hi, We have created a dashboard on OBI which has some dashboard prompts. We have a requirement that we shall open the dashboard from an external application. We are doing this by invoking an URL. We want the dashboard to turn with prompts already bei
Hi All I have a report on a dashboard page which navigates to another report on a different dashboard page (on the same dashboard). The first dashboard page has a prompt which needs to be passed as a filter to the navigated report i.e. Report1 on das
I have complex Direct Database Request query having Dashboard Prompt. In Dashboard prompt I want to have LOV. But to create the DPrompt having LOV, I must have the table/column in Subject Area. How I can have table in RPD not connected or joined with
I am using OBIEE 10g. I have a dashboard that prompts for a fiscal year and fiscal period (both are numeric data types). I need to use these values in the date filter for my answers request - however, to fully utilize the indexes and partitioning tha
Dear guys , am newbie to obiee .am using obiee 10.1.3.am develping dashboard with prompt but a little problem is here when i run dashboard prompt are displayed ,i give values to them as i press go button prompt page hide and my dashboard page is disp
I have created one dashboard with prompt but the prompts are not working as selected values as per prompt are not getting filtered out e.g. one of the prompt is "sales stage" if eventhough i select a particular sales stage it shows all results w
Dear Expert, I have prompt on my webi report and I am creating mobile dashboard on that. The mobile dashboard support Prompt. If yes then please let me know the procedure. Regards, Divyesh Patel. (9930578182)Hi Divyesh, There is no specific procedure