If you have access to the rpd and your state is in a dimension hierarchy level then you can create a MAX version of the measure in question and pin it (drag it or copy it) to the level in question, then you will have max that is invariant for the state in question.

In OBIEE you can use sum by in the formula; - sum(yourFact.YourMeasure by State) https://stackoverflow.com/questions/27066406/summing-by-column

Hello Kevin J, mush or no, make your problem clear and provide full detail and you are more likely to get a solution... We don't know what your employee / manager structure looks like, so my answer is based on assumptions / guesses - not the best situation... I suspect your requirement is better fulfilled in the ETL…

Hi Yaseen, imagine the following; - Fact A -> Time -< Fact B Now imagine Fact A has all levels of detail in the time hierarchy, Day / Month / Quarter / Year, but Fact B only has detail from the monthly level. So, if you ran a two fact query at anything down to Month level then all would be good. If you ran anything at day…

http://blog.whitehorses.nl/2016/01/18/visualize-database-data-with-oracle-jet/

On all matters of licensing best to refer to your Oracle Account Manager. Though - without prejudice - this blog would seem to say the licensing is covered if; - "free for customers who have visual cloud solutions or an on premise version such as VA"…

A couple of options; - https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=home&demo=rootVisualizations https://www.clearpeaks.com/adding-javascript-libraries-obiee/ & https://www.rittmanmead.com/blog/2016/07/obiee-12-2-1-1-0-new-feature-guide/ I'll leave others to the flaming, let he who has never…

Hi mmajdana1 - sorry not to get you across the line, but when you do find your answer would you mind kindly updating this thread for the benefit of others? Good luck with your SR! Robert.

Thanks - the value of the community is increased by everyone who wants to add as well as take value!

Hi Dennis, yes 'https://etc/etc ...' || your_variable1_here||'etc etc' - then make it html in the format - is what I had in mind. I did this first some years ago to provide drill out functionality from invoice data to scanned images - provided you have a predictable format and can access the parameters you are away...

And then again - some of the other notes talk about the library using 'machine entropy' to work out its seed, so it looks like not enough happening can be as bad as too much happening(!) Bottom line 'java' is now as much Oracle's as OBIEE - so I would raise that SR and if you can get them to recognise a bug then do upgrade…

Looking at more sites and the general opinion seems to be that this relates to volume of usage as the seed generation is resource intensive. See -> https://stackoverflow.com/questions/9885380/in-windows-java-securerandom-generateseed-failed-unexpected-cryptoapi-failur… Don't know if anyone has implemented the suggested fix…

re: "it worked fine and then the same issues started to come again"; given that the cryptography is java based is there any kind of automatic updates that could have updated the java library or any kind of security that could be getting in the way of it operating? Do you have a know working point in time back up that you…

See also; - 14.6.8 Enabling Lexicographical Sorting Lexicographical sorting is the ability to sort data in alphabetical order. Most data sources support lexicographical sorting. However, if you notice that lexicographical sorting is not working properly for a particular data source, then you can configure the Oracle BI…

Does this note apply to you; - "When the NLS_CHARACTERSET in the Oracle Database is set to a non-unicode derived code page, you must configure an additional metadata repository setting to make character sorting consistent between the Oracle Database and the Oracle BI Server. To modify the metadata repository when the…

Have a look at this on MOS -> Attempt to Navigate WebLogic Server Console Fails with java.lang.InternalError: Unexpected CryptoAPI failure generating seed (Doc ID 1492450.1) https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=131xcmaamw_4&_afrLoop=188723766580191

I would log an SR.

What you have should work - have you shut down and restarted the server after changing the settings?

On 'still english sort', can you provide details on what the column in question is, and what the sort order specified on that column is.

Have you seen -> Unexpected CryptoAPI failure generating seed