21094127 ADD FUSE CUSTOM.CSS APP STYLES TO ALTA 21127173 BI DEINSTALL THROWS EXCEPTIONS WHILE LAUNCHING DEINSTALLER IN COMMAND LINE 21158035 12C VA MASHUP DATASET INSPECT DIALOG TO INCLUDE PERMISSIONS TAB 21419316 QA:HGRID CAUSE&EFFECT AND STV WITH MANY COLS DON'T DISPLAY PROPERLY AS WATCHLIST 21438772 Fix for Bug 21438772 21527677 12C:BI: INSTRUCTION FOR ENTERING THE DOMAIN NAME NEEDS TO BE CHANGED 21529377 MDS XML INVALIDDATATYPEVALUEEXCEPTION, MESSAGE:ID 'MERROR' IS NOT UNIQUE 21658348 UNABLE TO FIND MAPPING.XML IN ALL UTIL LOGS IN ADMINTOOL CLIENT 21766161 Fix for Bug 21766161 21766173 Fix for Bug 21766173
1. How to upgrade, the Oracle way (there is an alternative at RittmaMead here).
2. What is OK to delete at the old home, to save space (actually, I didn't try that yet).
3. How to configure 2 new features:
a. Lightweight SSO that uses VA sign on
b. .dva import/export.
Regarding the Lightweight SSO, a quick reminder to myself:
If I had the OBI 22.214.171.124.0 installed at C:/oracle/Middleware/Oracle_Home, and the OBI 126.96.36.199.0 is now at C:/oracle/Middleware/Oracle_Home12212, the script to run is: enableBISingleSignOn('C:/oracle/Middleware/Oracle_Home/user_projects/domains/bi','/bi-security-login/logout?redirect=/va').
After the restart, when I login this is the screen:
If not happy with the SSO the following disables it: disableBISingleSignOn('C:/oracle/Middleware/Oracle_Home/user_projects/domains/bi')
I wanted to create COUNT(DISTINCT "Orders"."Order Number" by "Products"."Product Type") as a column in the repository, based on the default Sample Sales.
In the Sample Sales there is already a column that return COUNT(DISTINCT "Orders"."Order Number"). It's Name is # of orders and it is defined as "Count Distinct" aggregation on the Order_number key:
Basically the COUNT(DISTINCT "Orders"."Order Number" by "Products"."Product Type") is equivalent to Sum("# of Orders" by "Products"."Product Type"). For example:
I will use this logic in the RPD:
I duplicated the # of Orders column. In our case the aggregation by Products dimension should be sum, while by other dimension "Count Distinct", so turn on the "Based on dimensions" option and set it (use the Plus sign to add Logical Dimensions and select the formula from the pull down menu):
Now the last part is to set the levels, at the column to be by Product Type for products and Total for all the rest:
I didn't bother with column name so it's "# of Orders 1".