Also, don't know if Oracle's Big Data Discovery is an option for you; - https://www.rittmanmead.com/blog/2015/11/oracle-openworld-2015-roundup-part-2-data-integration-and-big-data-in-the-cloud… I was sure when I was in Oracle that there was mooted to be further integration between Big Data Discovery (Endeca as was) and…

Have you seen; - https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-F0C95568-34CD-4421-8A80-C5903C689B15.htm#data_direct_hive https://kirti-bi-solutions.blogspot.com/2016/10/apache-drill-obiee-12c-configuration.html Learning by experiment: Connecting OBIEE to Spark

Not wholly following what you are trying to explain, but if an analysis is on a dashboard page / tab then it will run when you open that dashboard page / tab. If an analysis is being used as the basis of a filter or conditional display logic then it too will run when you open that dashboard page / tab. If an agent is…

Lines of defense - so only on the failure of all layers is the data exposed to risk? Yes, that is superior to my database-centric - stance I agree!

Sincere apologies for my part in sowing discord amongst the Superheroes on the board, and sorry to re-raise the subject which you probably both consider closed, but I still feel the answer here should be to prevent it in the database layer, as an erstwhile plsql developer I know that is what I would do as a DBA if asked…

Hi, the optimal way to do this is by having a fiscal year (I assume that is what it is) hierarchy set up for your date dimension(s) and a repository variable, current_fiscal_year that you update using timed sql along with the rest of the repository variables. You might want to see posts like this for the sub-optimal way of…

Hi Gianni, happy to be wrong but I would defend my 'yes' by saying that evaluate is very widely used and the question was around 'possible', so 'yes', it is possible, but only if both the connection pool user has sufficient rights and as you rightly state that evaluate is configured to be useable. I would also mention…

Yes, things like evaluate expose the databases, which is why your connection pool connections should be users with very restricted rights against the database.

Hi, we are not a formal help desk here, there is no SLA, but I do check fairly regularly in GMT office hours (and out of) so any problems just ask and I will try to clarify.

So, in a nutshell. 1. The user logs in, here an initialization session variable is populated 2. When the user accesses the dimension / fact table in question the extra query runs to filter the rows of data, basically joining the 'group' the user is in, to the rows of data they are allowed to see, and using this as a filter…

Hi, I suspect the extra query against FCT_SHIPMENT_UNIT is because the security has been applied to work via that fact table. Have a look at this to understand how row level security is applied => https://www.rittmanmead.com/blog/2012/03/obiee-11g-security-week-row-level-security/ See the section on session variable…

Hi, sorry to interject Christian, but this is basics...2845107 you are hurting me.... Time Dimension year: key 2018 quarter: key 201803 month: key 201807 datekey: 24072018 (or wid is good!!) Also set number of elements to give OBIEE a hand along the lines of 365 / 12 / 4 / 1 Set this up in your time dimension, using each…

Hi, as a starter, set your diagnostics so you can view the physical sql in the logs. Run the analyses with your test users. Compare the two sets of physical SQL that are generated.

Possible -> https://www.clearpeaks.com/adding-javascript-libraries-obiee/ Have a look at the code; - var dim = new Array(5) for (i=0; i <5; i++) dim[i] = new Array(2); var max_i; dim[@1][0] = "@2"; dim[@1][1] = @3; max_i = @1; Crib this and alter it to your needs and you are there... BUT - better would be to get your data…

If I answered your question can you kindly close it for the benefit of others in the community. If you are not sure how then you can use 'Assumed Answered' if you feel you don't want to give points, or mark a reply 'Answered' if you do and want to point others to what you feel answered your question.

And if no one has the filter associated with them via group membership then the filter will do nothing at all.

Yes, you understand me correctly, if any users have this filter associated with them via a group membership then that filter will always be applied to any analysis that that user runs on that subject area.

Hi, typically these are used to apply data / row level security, so your filter is limiting the group in question to be only able to see Global Logistics.Logistics Claim.Limit Filter = 0 in addition (AND Global Logistics....) to any other filters that are applied in the analysis. In your case anyone who has the filter…

For guidance on chronological key set up see -> https://gerardnico.com/dat/obiee/obis/time_dimension (dated but still relevant) And for guidance on ago -> https://gerardnico.com/dat/obiee/obis/logical_sql/ago

Hi, you don't have to change anything in the reports when you alias a column in the presentation layer, it just works without a rewrite. So you either need to go back to the prechanged version of the report(s) or refresh the field(s) in question in the report.