OBIEE query caching is an interesting topic with many trade offs whichever side of the fence you're standing on. Without delving into that, a solution (although not ideal) is to seed the logical query of your report without any filters to ensure that any report run with filters will run from this cache. Just seen @Robert…

The Logical Level is what you should be using in the Period Rolling function In the screenshot above, this would be: "Usage Tracking"."Time Hierarchy"."Month"

Can you try a different Connection Pool to test this?

@Gianni Ceresa has already suggested that you use the SUM of the Absolute of the measure to compare against the SUM of the measure by whatever you're aggregating in your table. If the SUM of your measure is different from the SUM of Absolute components then you know the row has at least a negative record. This can be used…

Go to the <Domain_Home>/pending directory. There are temp cached configuration files with changes made from console. Stop the Admin Server, and replace the config.xml from the <Domain_Home>/config directory with the config.xml from the <Domain_Home>/pending directory. Look for all .lok files in the <Domain_Home> directory…

Hi @Ganim Altiok Your last screenshot seems to indicate that you're pointing the Config Assistant at a 12.2.1.1.0 domain. Confirm that you've followed all the upgrade steps.

Hi @user1137177 Does the D: \OBIEE12cDEVInt\oracle_common\common\nodemanager\security\DemoIdentity.jks keystore file exist in the location?

Well spotted @Gianni Ceresa! Duplicating questions doesn't double the chance of your issue being resolved, it has the reverse effect...

Your question isn't very clear. If you've set the dashboard prompt scope to Dashboard then it should work across all pages within the dashboard. If on the other hand you set the scope to page, the prompt would only apply to reports on that specific page. This is OOTB functionality.

Try this: CASE WHEN '@{PV_Negative}{ALL}' = 'ALL' THEN "-Analysis"."Balance - units" WHEN '@{PV_Negative}{ALL}' <> 'ALL' THEN CASE WHEN "-Analysis"."Balance - units" < 0 THEN "-Analysis"."Balance - units" END END please note that I haven't tested this logic but something like this should do the trick...

Your dashboard prompt needs to populate a presentation variable based on the selection. If user select -ve then you need to have a CASe statement in your measure that checks the presentation variable and then only return measure values < 0 and the ELSE condition should return all values.

The error is quite clear: Message returned from OBIS. [nQSError: 27045] Nonexistent column: "Schedule Ship Period"."CAL_WEEK_DESC". You are referencing a column that doesn't exist in your rpd.

Can you provide information about your OBIEE version? Also, have you checked the query log files to see what query has been generated by the BI server? Screenshots are always useful to enable people to properly visualize your issue.

I have the exact OS, OBIEE & OPatch versions as you and I've applied several patches without any issues, so yes, no need to update.

The 13.9 OPatch version should be fine. https://support.oracle.com/MMOS/faces/ui/km/kmDocumentDisplay.jspx?kmDocId=1587524.1&idx=0&totalResultsDisplayed=10

Check WebLogic as well, you may have some stuck threads: Oracle Support Document 1906192.1 (OBIEE 11g: Troubleshooting Stuck Threads or Hangs) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1906192.1

Just to add to @Gianni Ceresaresponse above, I'd check the query log files to check whether the filters are being correctly set for each of the scenarios.

Can you try this: ('@{v_period}['@']')

Excellent. In order to help other users of the forum, mark the answer as correct.

Based on what I mentioned previously, all you need to do is to access the column properties > interaction tab (see my screenshot) and one of the interaction types is "invoke a script" . You just need to add a condition to ensure that the column value determines the action link that is called.