If your users are missing cache, you might find the service request below helpful.
Description:
User1 one and User 2 have the same profile but User 2 is not hitting User 1’s cache even though the physical queries are exactly the same.
Cause
Customer had implemented data-level security. This resulted in different SQL for each user.
Solution
Cache hits are not based upon the physical queries.
They were using session variables in the connection pool login/password fields. Each different login has a different query, the issuer of the query is different, this results in the cache being specific to a user / session variable.
They modified the connection pool to use a shared login/password and this resulted in a cache hit.
Something else, I’ve found. I suggest always adding 1.00* when working with non-integers, just for sake of convenience.
(Customers.”Total Customers” / sum(Customers.”Total Customers”)) * 100
Cause
The problem was caused because that Integer Data Type values are involved in the calculation. If the calculation is performed on Integer values, then the correct answer is ‘0′.
When a Grand Total is specified, then the Data Type is promoted to Double Precision. If the operation is performed on a Double Precision field, then non-zero values will be returned.
Solution
The solution to this issue and to ensure that non-zero values can always be returned in an OBI EE Report is by modifying the formula expression as follows: -
e.g. (1.0*Customers.”Total Customers” / sum(Customers.”Total Customers”)) * 100 or 1000*Customers.”Total Customers” / sum(Customers.”Total Customers”)
When viewing the properties of a fact column in OBIEE, there is a check box “data is dense” when aggregating by dimension is chosen. What does this check box do? I’m not sure if this only applies to multi-dimensional sources or not.
Solution
This is generally used for FIRST/LAST aggregation rules where data is dense across the time dimension, e.g. inventory values for every period. SQL generation is optimized in this case.
I found an excellent post about OBIEE LDAP security for users the link to the topic is here: http://forums.oracle.com/forums/thread.jspa?threadID=843503&tstart=15 and that discussion is pointing to this useful LDAP security configuration article on Mark Rittman and John Mead’s blog.
I’ve decided I’m going to put review of the most useful and most hot topics from the Oracle’s discussion.
#1. “Thread: Whats Business Inteligence Suite?” -
OBIEE Kenobi is giving a good amount of resources for starters, including Mark Rittman’s blog. Definitely worth giving a look, if you’re new to bi solutions or obiee.
#2. Calculations using Physical Tables vs Logical Tables asked by Mark Thomspon
Kishore Guggilla and wobiee1 answered the question almost at the same time. I really liked the short and consise description of ” The Physical vs Logical has an impact as you already described:
Logical will first aggregate and then calculate. This is the case with a lot of measures just as your example sales/profit.”
#3. What are time-series?
This is one of the most common questions – setting up time series functions. Few experts are giving their few to what they consider to be time series in OBIEE. They also portray examples of such functions as AGO and TODATE. OBIEE has several options for implementing time , however, I recommend canonical time – it’s slightly more difficult to implement – but is more beneficial for your bi system.