Posted by: michaelverzijl | 05/12/2012

Output Excel changed 11.1.1.6.4+

While doing an upgrade to 11.1.1.6.6, I was faced with an issue on the Excel download of a report.

The report in OBIEE:

ScreenShot696

 

While downloading to Excel the report changed to:

ScreenShot697

Column repetition was ignored. A support request resulted in patch 14013626 that changed the functionality for these downloads.
This functionality was created to be able to sort Pivot tables in Excel.

Bug 14839368 was created to make this functionality optional in future releases (planned for 11.1.1.7)

Posted by: michaelverzijl | 30/11/2012

Zoom to data Range available in OBIEE 11g

While doing migrations from OBIEE 10g to OBIEE 11g, several clients complain about missing the zoom to data range functionality.
This was a nice feature in 10g, but Oracle decided to leave it out 11g.

From OBIEE 11.1.1.6.5+ this feature is available again.

How does it work?

Imagine a graph that looks like this:
ScreenShot684
From the Graph it’s hard to tell what the difference is.

In the options of the graph a new option is available:

ScreenShot685

When this option is changed, the graph looks like this:

ScreenShot686

 

The Y-Axis now starts at 570k, instead of 0.
It’s nice to see that this feature is back in 11g!

 

Posted by: michaelverzijl | 23/08/2012

Weblogic – WLST get users and groups

Sometimes it can be handy to retrieve all users and groups from the internal weblogic security provider.
To do this follow these steps:

  1. Create defaults.properties
  2. Set Weblogic environment
  3. Execute script

defaults.properties:

Don’t forget to change the URL, username and Password:

admin.url=t3://localhost:7001
admin.userName=weblogic
admin.password=<PWD>

# User Name which wants to get listed (where, * = all users name) #
user.name.wildcard=*

# Maximum Numbers of List you want to see (where, 0 = all the number of users) #
maximum.to.return=0

Set weblogic environment

Execure the file:
FMW_HOME\wlserver_10.3\server\bin\setWLSEnv.cmd/sh

Execute script
The following script will result in the users and the groups (separated by a “;”):

from java.io import FileInputStream</pre>
from weblogic.management.security.authentication import UserReaderMBean
from weblogic.management.security.authentication import GroupReaderMBean
from weblogic.management.security.authentication import MemberGroupListerMBean

propInputStream = FileInputStream("details.properties")
configProps = Properties()
configProps.load(propInputStream)

adminURL=configProps.get("admin.url")
adminUserName=configProps.get("admin.userName")
adminPassword=configProps.get("admin.password")
userNameWildcard=configProps.get("user.name.wildcard")
maximumToReturn=configProps.get("maximum.to.return")
showAllAuthenticatorUserList=configProps.get("show.all.authenticator.userlist")

connect(adminUserName, adminPassword, adminURL)

realmName=cmo.getSecurityConfiguration().getDefaultRealm()
authProvider = realmName.getAuthenticationProviders()

for i in authProvider:
if isinstance(i,UserReaderMBean):
userName = i
userReader1 = i
authName= i.getName()
userList = i.listUsers(str(userNameWildcard),int(maximumToReturn))
print '======================================================================'
print 'Below are the List of USERS which are in the: "'+authName+'"'
print '======================================================================'
num=1
while userName.haveCurrent(userList):
cursor1=i.listMemberGroups(userName.getCurrentName(userList))
while userReader1.haveCurrent(cursor1):
print userName.getCurrentName(userList) + ';'+userReader1.getCurrentName(cursor1)
userReader1.advance(cursor1)
#userReader1.close(cursor1)
userName.advance(userList)
num=num+1
print '======================================================================'
userName.close(userList)

The script can be executed by: java weblogic.WLST userlist.py > logging.txt

My thanks go out to: http://middlewaremagic.com/weblogic/

Posted by: michaelverzijl | 29/05/2012

OBIEE 11.1.1.6 Export to Excel [solved!]

A while ago I wrote a post on OBIEE 11.1.1.6 and exporting to Excel. You can find this post here.

In the meantime Oracle has provided a patch to solve this issue.
First of all you need to upgrade to OBIEE 11.1.1.6.1 with patch 13742915.

After installing this patch you also need to install 14003822 on top of this patch.
Please be aware that patch 14003822 is a Patch Set Exception. In the readme the following is written:

This one-off patch has undergone only basic unit testing. It has not been
through the complete test cycle that is generally followed for a production
patch set. Though the fix in this one-off patch rectifies the bug, Oracle
Corporation will not be responsible for other issues that may arise due to
this fix. Oracle Corporation recommends that you upgrade to the next
production patch set, when it is available. Applying this one-off patch could
overwrite other one-off patches applied since the last patch set. Customers
need to request Oracle Support for a patch that includes those fixes as well
as inform Oracle Support about all the PSE installed when an SR is opened.
Please download, test, and provide feedback as soon as possible to assist in
the timely resolution of this problem.

So: please do test this patch before applying this to production.

Posted by: michaelverzijl | 22/05/2012

Member not found in Internet Explorer

Today a client faced an error while opening a converted report from 10g to 11g.This error showed as “Member not found”. Cause of this error is a setting that is not enabled in IE.

To solve this error:

1. In Internet Explorer, click on the Tools/InternetOptions menu item.
2. Click on the Advanced tab.
3. Under the Security setting, click on the check box Enable Native XMLHRRP Support

(Also see MOS ID 1283957.1)

Posted by: michaelverzijl | 10/04/2012

OBI 11.1.1.5 Bundle patch 2 released

Today Oracle BI 11.1.1.5.0 Bundle Patch 2 is released
It’s patch number 13611078  on MOS and can be downloaded without password.

For more information look here

In total 190 bugs are fixed in this release:

BUG ID

Description

7265385

SQL MULTI SELECT PROMPT LOSES CONDITION WHEN SEARCH

10210633

ERR CODE: EIRWWH9E – EMPTY STRING ERROR CREATING CALCULATION IF A FIELD IS NULL

10232312

SORT ICONS NOT SELECTABLE WITH FIREFOX WTIH LARGE NUMBER OF COLUMNS

10298197

1 ROW OF EMPTY RESULTS WHEN MAX(RCOUNT(1)) IS IN PROJECTION.

10310311

ODBC CRASHES WHEN A DSN IS CREATED USING BISERVER ODBC DRIVER ON WINDOWS 2008

10633330

DO NOT DISPLAY IN A POPUP OPTION ACTION LINK INCORRECT BEHAVIOR

10647655

COLUMN DATA FORMAT IS IGNORED ON WRITEBACK

11700314

REPORT NOT EXPORTED FULLY INTO EXCEL WHEN DOWNLOADING FROM PAGES OTHER THAN 1

11717987

INCORRECT ESSBASE MDX GENERATED FOR COMPLEX FILTERS WITH AND/OR

11772408

XML ERROR IN A PIVOT TABLE WITH GRAND TOTAL WHEN TRYING TO FORMATTING LABEL

11802400

COLUMN HEADERS SHOW INCORRECT FOLDER WHEN HIDING COLUMNS

11810367

CONSISTENCY CHECK – OPTION TO TURN OFF (AND ON) CERTAIN WARNINGS

11823765

SIGNIFCANT PERFORMANCE DIFFERENCE BETWEEN PIVOT AND TABULAR VIEWS

11837656

NLS:THE EXPORTED CSV WOULD BECOME MISALIGNED WHEN TITLE OR VALUE CONTAIN COMMAS

11845571

QA: NO POINTER IS SHOWING UP FOR GAUGES

11882495

DRILL DOWN BREAKS ON PRODUCT IN SAMPLE APPS ON ESSBASE

11890139

PARENT CHILD HIEARCHY THROWING ERROR WHEN USING FRAGMENTATION IN SOURCES

11897206

RENAME OF FOLDER IS NOT ATOMIC AND LEAVES TWO CHUNKS OF ORIGINAL

11924932

PERFORMANCE ISSUES IN 11G

12344432

CARA:AMAZON:XML VALIDATIONS: QUERYITEM1 — 8

12344465

CARE:AMAZON:XML VALIDATION:CODASHBOARDSELECTIONS1 –2

12352010

RESTRICTED COLUMNS SHOULD NOT SHOW IN SUBJECT AREA.

12373034

SEARCH DIALOG BOX IS SLOW WHEN THERE IS AN EXISTING FILTER

12376825

SSAS USING SUB-SELECTION IN MDX CODE GENERATION.

12377693

ASENG: ERROR MESSAGE WHEN USING FORMULAS IN FIELDS

12394949

ASENG:RC3: EXPORT TO EXCEL DOES NOT HONOR ‘DECIMAL PLACES’ COLUMN PROPEPERTY

12396205

MISSING REPORT LINKS FOR REPORTS IN A CATALOG FOLDER ON A DASHBOARD

12399693

LD1 B17.1: INV VAL AND GROSS MARGIN REPORT TABLE – INVALID PATH ERROR

12399899

PERFORMANCE IMPROVEMENT – REMOVE CENTER QUERIES FOR PAGE SLICES NOT DISPLAYED

12411977

TERADATA RANK() IS NOT ALLOWED IN THE SUBQUERY

12534231

CRMQA_RRF, ST3B17.1: SPE TRAINING JOB FAILS WITH NULLPOINTEREXCEPTION

12535513

CONDITIONAL SELECTION STEP WHEN SPECIFYING MATCH SESSION VARIABLE NOT WORKING

12544465

BIPS STATEPOOL DOES NOT UPDATE LAST ACCESSED TIME – INVALID STATE IDENTIFIER

12546862

PIVOT TABLE ‘PERCENT OF COLUMN’ DATA DISPLAY BADLY WHEN LOGGED IN TURKISH

12561330

DRILL DOWN REPORTS WITH SQL FILTER ARE ERRORING OUT IN SYSTEM TEST ENV

12562702

PERIODICALLY CALL MACOMPACT()

12565506

BIP REPORT USING PRES VAR IN FILTER FUNCTION IN COLUMN FORMULA NOT FILTERING

12577234

ISSUE WITH PRESENTATION VARIABLE EFFECTING PROMPT

12578133

DATE LITERALS NOT SUPPORTED FOR MSFT ANALYSIS SERVICES

12583085

500 INTERNAL SERVER ERROR FOR A FEW REQUEST AFTER UPGRADE FROM 10G TO 11.1.1.3

12583341

PREFIX IS LOST WHEN NAVIGATING TO CRITERIA OR RESULTS TAB

12587004

EXPORT TO EXCEL CORRUPT VALUES THAT ARE PART OF A % IN TURKISH

12587722

AFTER UPGRADE TO 11.1.1.5 CANNOT FUNCTION SHIP ERROR FOR ESSBASE EVAL FUNCTIONS

12594007

AGGREGATED COLUMNS THAT CONTAIN NULL RESULT IN NO DATA WHEN GRAND TOTAL ADDED

12609751

AFTER UPGRADE, PIVOT TABLE CALC ITEM W/ HIDE DETAILS HAS INCONSISTENT TOTALS

12609868

INTERNAL SERVER ERROR WHILE BROWSING DASHBOARDS USING CATALOG NAVIGATION PANE

12612904

TOTAL PICKS VALUE IN FIRST ROW AND GIVES NOT A NUMBER WHEN AVERAGING NULL

12617883

VARCHAR DATATYPE NOT SUPPORTED FOR FILTER METRICS USING PARAMETERS OVER JDBC

12628039

SUPPORT MORE THAN ONE HIERARCHY FROM THE SAME DIMENSION FOR MS ANALYSIS SERVICES

12632151

REQUEST VARIABLES ARE NOT PASSED FOR A LONG RUNNING QUERY

12632611

ERROR WHILE EXPANDING HIERARCHY COLUMN WITH CACHE ENABLED

12633881

WEBCATALOG GETS SEVERELY CORRUPTED AFTER MIGRATION/UPGRADE FROM 10G TO 11.1.1.5

12638186

EXCEL EXPORT GENERATES A SPACE BEHIND ANY MEASURE VALUE WHEN USING ACTION LINK

12643093

WHEN EXPORT TO EXCEL, ZERO VALUES APPEAR TO BE BLANK

12661967

PRES VAR YEAR-1 DISPLAYS @{YEAR -1} IN COLUMN HEADING AND NOT VALUE

12662417

CALCULATED ITEM DISAPPEARS FROM REPORTS (AFTER APPLYING BUG 12587870 PATCH)

12667254

LDAP ATTRIBUTES NOT APPEARING IN SYSTEM PROFILE SO NOT AVAILABLE TO DELIVERS

12669280

‘HIDE DETAILS’ OPTION NOT DISPLAYED FOR NEW CALC ITEM IN COMBINED REQUEST

12669338

IBOT AGENT CONDITION NOT WORKING WITH DIRECT DATABASE REQUESTS

12675796

QA: MLR:REG ASSERTION ERR AFTER CHANGE LAYOUT, VALUE HIER NO DRILL, FILTER DRILL

12679383

PROTECTED FILTER SHOULD NOT PICK UP PROMPT VALUES

12687823

CORE DUMP FROM LARGE PLAN CACHE

12687949

ACT AS FUNCTIONALITY IN 11.1.1.5 DIRECT TO HOME, NOT USER DEFAULT DASHBOARD

12693390

UPGRADING TO 11.1.1.5 FROM 10.1.3.4.1 AGGR ALONG ESSBASE DIMENSION CAUSES ERROR

12701483

BAD PERFORMANCE IN A PIVOT TABLE WITH ESSBASE AND UNCHECKUSE UNQUALIFIED MEMBER

12708184

ANONYMOUS BLOCK IN CONNECTION SCRIPT CAUSES ORA-6550 ERROR ON ROW COUNT

12715581

PRESENTATION VARIABLE VALUES NOT PASSED CORRECTLY IF VALUE CONTAINS QUOTES

12715885

HORIZONTAL ALIGNMENT WON’T WORK FOR NARRATIVE, STATIC TEXT VIEW IF EXPORT TO PDF

12717149

PERFORMANCE ISSUE IN VALUE HIERARCHY DRILL ISSUE – WITH ESSBASE ALIAS COLUMNS

12720664

VARIABLE NOT WORKING AS EXPECTED AFTER NAVIGATING TO A PAGE WITH LONG QUERY

12721517

EXPORTED TITLE DISPLAYS INCORRRECT VALUE WHEN PRES VAR IS SET AS ALL CHOICES

12727616

ACTION LINK FROM PARENT W/ SUBQUERY TO CHILD REPORT LOSES FILTER PROMPTS

12729332

PAGE EDGE QUERY OPTION FOR ALL PAGES OR SEPARATE QUERY

12732606

HIERARCHICAL PROMPT WITHOUT SELECTIONS APPLIED INCONSISTENTLY

12734649

PSR:OBIPS CRASHED/CORE DURING DOWN TIME IN LD1B18 ENV

12739309

PSR:PERF:BI OBIS RESPONSE TIME GOES UP TO 500SECONDS+ WHEN RUNNING SCOTIA RPD

12741534

OBIEE 11G 11.1.1.5 MSSAS DOUBLE COLUMN CAPTION DISPLAY

12741655

BYPASS ORACLE BI PRESENTATION SERVICES CACHE NOT USABLE WITH HIERARCHICAL COLS

12756905

PRESENTATION VARIABLE FILTER ERRORS IF DEFAULT VALUE IS %

12758061

AFTER UPGRADE, ISSUE WITH TREAT AS ATTRIBUTE PROPERTY

12761316

NESTED 2+ SAVED FILTERS IN A DASHBOARD PROMPT DOES NOT WORK IN 11.1.1.5

12761355

UNABLE TO PRESS OK ON CHART PROPERTIES FOR GAUGES.

12764435

DASHBOARD SECTION CONDITIONS NOT UPDATED WHEN REFRESHING DASHBOARD

12766173

HEADER DOESN’T WORK PROPERLY AFTER UPGRADE TO 11G

12769254

OBIEE 11.1.1.5 – NOETIX 10G CATALOG UPGRADE FAILS

12776974

SUPPORT FOR 2 MODES IN PAGE QUERY: 1. FROM CUBE OR 2. SEPARATE AXIS QUERY

12777172

POSITIONAL CALCULATE ITEMS NOT CALCULATED CORRECTLY IF HIERARCHY IN OTHER EDGES

12779543

DASHBOARD ERROR CATALOG OBJECT SCHEMA VALIDATION FAILED AGFIXBO2:EIRWWH9E

12791684

ERROR IN THE QUERY GENERATED BY OBIEE WHILE THE PROMPT DEFAULT SQL FAILED.

12796744

UI OPTION FOR ALL PAGES OR SEPARATE QUERY WHEN POPULATING VIEW PAGE PROMPTS

12800814

PSR:PERF:BI THERE ARE SOME MEMORY LEAKS IN SAS(OBIS)

12806276

IT IS NOT POSSIBLE TO DRAG A DIM COLUMN TO A PIVOT TABLE PROMPT IN 11.1.1.5.0

12806562

PRESENTATION VARIABLES KEEPING VALUES WHEN THEY SHOULD BE NULL

12810401

PIVOT TABLE SECTIONS SHOW ZEROS (0) FOR SOME CALC ITEMS

12821662

SEVERE PERFORMANCE DEGRADATION WITH PIVOT TABLE PROMPT OVER OLAP SOURCE

12825306

EDIT FORMULA: SHARED FILTER GIVE OBJECT EXPECTED JAVASCRIPT ERROR

12834582

REG: CANNOT SET BIPUBLISHER REPORT TIME ZONE FROM MY ACCOUNT DIALOG

12844774

SHOW WRONG COLUMN FORMULA OF UNION ANALYSIS

12850289

COLUMNS ARE NOT IMPORTED FROM SYBASE IQ 64BIT WHEN THE TABLE NAME HAS UNDERSCORE

12853576

HIERARCHY IN PROMPT DOESN’T DISPLAY VALUES IN IE7 UNTIL THE DIALOG IS MOVED

12860823

SUM(MEASURE BY ENTITY) ROW ADDED -> SHOW AS PERCENT OF COLUMN DOESN’T WORK

12874242

PATCH FOR BUG 12736571 INTRODUCES UNDESIRED BEHAVIOR

12877995

FIREFOX 10: BROWSERS WITH VERSION GREATER THAN 10 REPORTED AS NOT SUPPORTED

12879300

DRILL THROWS [NQSERROR: 59137] FILTER LEVEL XXX IS BELOW YYY

12897439

PRESENTATION SERVICES CRASHES WITH CERTAIN QUERIES

12908818

EDIT COLUMN FORMULA NOT WORKING IN FIREFOX

12909000

QA: REG:UI: SELECTION STEPS PANE – LOCATION OF EDIT/DELETE ICON

12909840

ERROR : [46036] INTERNAL ASSERTION AFTER SAVING ONLINE RPD CHANGES

12914177

UI CHANGES TO RESPOND TO IS ISUSERSECURITYINVISIBLE() FALSE

12921997

DONT CREATE COLUMN NODE IN COLUMNS PICKER WHEN COLUMN IS NOT ACCESSIBLE

12922186

REQUEST NAME IS APPEARING IN TABLE PROMPT IF THE REQUEST HAS A PROMPT

12934869

PUBLISH PAGE TO DASHBOARD DOES NOT CREATE OR USE NEW OBJECTS

12937182

AFTER UPGRADE, COLUMN PROPERTIES ARE NOT WORKING IN COLUMN SELECTOR

12939713

MAX TIME QUERY LIMIT GOVERNOR DOES NOT CANCEL THE DATABASE QUERY

12940837

IE DISPLAYS MULTIPLE X , Y AXIS BROWSER SCOLL BAR AFTER DRILLING IN DASHBOARD

12950704

MEASURE BASED SORT DOESN’T WORK WHEN VIEW IS IN DETAIL GRAIN

12965257

NQSERROR 42039 OCCURS WHEN USING DATA FILTER

12969300

GETTING ERROR OAMP2OPY:U5V5TIAH WITH SOME REPORTS AFTER APPLYING PATCH 12899699

12976029

IN IE, DASHBOARD PROMPT’S EDIT WINDOW GOES OUT OF BROWSER BOUNDARY

12978196

COLUMN SELECTOR DOES NOT PASS VALUES FROM SUMMARY REPORT TO DETAILED REPORT

12981896

MAPVIEWER HOVER TOOLTIPS SHOW WRONG VALUES

12982344

MAPVIEWER TOOLTIP DOES NOT SHOW VALUE FOR MULTI-COLUMN BI-KEY.

12992697

PAGE BREAK WITH COLUMN BREAK DOES NOT WORK WHEN USE PRINTABLE HTML

12993928

LIFETIMEGUARD NOT THREADSAFE

13004557

DRILL ON A MEMBER IS NOT WORKING

13030883

IN A VIEW SELECTOR, IF DRILL IN PIVOT TABLE AND RETURN, GOES TO THE DEFAULT VIEW

13031147

CANNOT DELETE A HIDDEN MEASURE EVEN IF ANOTHER MEASURE EXISTS IN A PIVOT TABLE

13031395

GRAND TOTAL SHOWN INCORRECT RESULTS

13034629

EIRWWH9E ERROR HAPPENED WHEN SETTING PAGING CONTROLS HIDE VALUE

13040363

BUG 12790703 -> BASE BUG 12609751 STILL REPRODUCES AFTER PATCH 12609751

13043745

PIVOT TABLE’S LAYOUT COLLAPSES WHEN HIDDEN ROW AND TOTALS BEFORE IS USED

13054445

REPLACING NULL VALUES WITH 0 IN AN OBIEE 11G PIVOT TABLE IS NOT WORKING

13056782

SAWSERVER.EXE CRASH

13063155

FATAL:INVALID STATE IDENTIFIER -1006880667 ERROR

13067844

RED ‘WRITE BACK ERROR’ MESSAGE IN 11.1.1.5 – REGRESSION FROM 11.1.1.3

13071711

CIRCULAR JOIN ERROR WHEN RUNNING ANALYSIS USING UPGRADED REPOSITORY

13072653

NAVIGATING FROM PORTAL TO OBIEE DASHBOARD THROWS A LOGIN PAGE OCCASIONALLY

13083074

PROMPTS CREATING UNSPECIFIED ERROR WHEN SELECTING MULTIPLE CONSTRAINED CRITERIA

13087113

UPGRADED 10G DASHBOARD FAILS WITH ASSERTION FAILURE: (*IBASEFORMULA).GETNAME() =

13088771

DRILL DOWN CAUSES PIVOT TO SHOW ROWS THAT DEFAULT TO HIDDEN IN 10G

13096133

ERROR OCCURS WHEN DISPLAYING A RUNNING SUM IN PIVOT TABLE IN DIRECT DB REQUEST

13098323

AN ARITHMETIC OPERATION IS BEING CARRIED OUT ON A NON-NUMERIC TYPE

13107569

INCORRECT TOTALS IN GRAPH PIVOT TABLE VIEW

13111799

GRAPHING ENGINE IS NOT RESPONDING ERROR HAPPENED.

13249783

AFTER APPLY PATCH 129725592 OBIEE 11G THROWS BAD XML INSTANCE

13253545

ADDING A NEW GROUP SHOWS EMPTY COLUMN

13263142

HC SELECTION NOT SHOWING TEXT WITH SPECIAL CHARACTER (SINGLE QUOTE) WHEN APPLY

13321507

ITEM STALE ERROR WITH NETAPP ON WRITING THE SAME .ATR FILE BACK TO BACK

13332501

ASSERTION FAILURE: !SFORMULA.EMPTY() .. RESULTS IN NQSSERVER CORE DUMP

13350175

ADDING FILTER TO DIFFERENT LEVELS OF A HIERARCHY GETS IGNORED IN MDX

13359653

ANALYSIS QUERY IS NOT CANCELED PROPERLY.

13360538

MAPVIEWER DISPLAYS THE MEASURE VALUE WITHOUT MEASURE NAME

13362302

CHANGES MADE TO ONLINE BI SERVER USING BISERVERXMLCLI IS NOT UPDATED IN RPD FILE

13370386

THE CURRENT XML IS INVALID WITH THE FOLLOWING ERRORS: BAD XML INSTANCE! OCCURS

13393602

RSUM NOT CALCULATING CORRECTLY WHEN THERE ARE EXCLUDED COLUMNS

13400140

MULTI-STEP PROMT MISSING THE DASHBOARD PROMPT WHICH LIMIT VALUES BY IS SET

13401386

AUTO PREVIEW ARE NOT PREVENTED EXCEPT PIVOT VIEW

13403816

AFTER APPLIED MLR 13110245 STILL HAVING THE HIERARCHICAL PROMPT ISSUE

13403822

LIMIT BY ALL PROMPTS NOT WORKING WHEN MORE THAN THREE PROMPTS USED.

13405110

OPENING REPORT CRASHES BI PRESENTATION SERVICES

13418590

EXPORT TO EXCEL STILL NOT WORKING PROPERLY AFTER PATCH 12394949 (LINUX 64)

13437652

QA:CLICKED BACK BUTTON,FACING’FATAL:UNABLE TO FIND THE REQUESTED STATE IDENTIFER

13444157

ERROR WHEN USE IS IN TOP OPERATOR IN FILTER WITH PRESENTATION VARIABLE

13449747

ACCESS: PIVOT TABLE CONTEXT MENU NOT WORKING WITH KEYBOARD

13470294

BI PRESENTATION SERVICE FAILS TO START IN PARALLEL WITH OTHER BI COMPONENTS

13494385

THE SCROLL BAR OF RESULT PREVIEW WINDOW.

13498910

BI APPS DEBT TO EQUITY REPORT RETURNS SQXNQAGGRBREAKPROCESSOR ERROR IN 11.1.1.5

13501903

PATCH FOR BUG 11837656 DOES NOT FIX THE ISSUE WITH DOUBLE QUOTES

13516292

REPOSITORY INIT BLOCKS LOSE CONNECTION TO DATABASE AND NEVER REGAIN IT

13517767

POSITIONAL CALC CAN CAUSE XMLWRITER EMPTY DOCUMENT ERROR

13522060

RPD SESSION VARIABLE UNABLE TO IDENTIFY THE DYNAMIC SCHEMA NAMES FOR OLAP

13522214

VALUE-BASED HIER PROMPT SEARCH RESULTS IN ODBC ERROR

13523548

ERROR OUT WHEN USING MULTIPLE DOUBLE COLUMNS IN SAVED FILTERS

13526747

PATCH 13342140 DOES NOT CORRECT PIVOT CHART LEGEND ISSUES.

13535937

NEGATIVE VALUE IN CACHE MANAGER

13542805

BAD CACHE ENTRY BEING GENERATED

13546009

SELECT PIVOT TABLE IN VIEW SELECTOR CAUSES COLUMN TO BE EXCLUDED WHEN DRILLING

13567100

CASE WHEN USED IN MEASURE IN PIVOT IS NOT WORKING AS IN 10G

13610379

UNABLE TO CHANGE TIME ZONE IN USER PREFERENCES/GLOBALLY IN OBIEE 11G FOR BIP

13616593

AUTO PREVIEW ARE NOT PREVENTED FOR GRAPH

13625435

RUP2-ST-CDRM:FORMMATING AND ACTION LINK ISSUE AFTER PS5 UPGRADE

13626098

RUP2-ST-CDRM: DRILL DOWN REPORT NOT RETURNING OUTPUT.

13631676

OBIEE 11G – BISERVER ASSERTION ERROR AFTER APPLYING 13562882 PATCH

13647309

OBIEE GRAND TOTAL FUNCTIONALITY INCORRECT AND INCONSISTENT WITH OLAP CUBES

13680310

ERROR DISPLAYING VIEW WITH NESTED AND SAVED CALC ITEMS

13682411

CALC ITEM NOT DISPLAYED IN A PIVOT TABLE AFTER PATCH 13544352

13739082

QA: ASSERTION ERROR IF VALUE HIER WITH CALC ITEM MOVE TO PAGE/PROMPTS EDGE

13774635

OBIPS THROWING ASSERTION WHILE RUNNING THE CACHE SEEDING AGENT

13779997

QA: CHART NO DISPLAY -VALUE HIER CHILDREN IF CRITERIA CONDIT FORMAT MEAS

13791266

CUSTOM GROUP SELECTED IN VALUE HIERARHCY PAGE EDGE DOES NOT WORK

Posted by: michaelverzijl | 28/03/2012

OBI: exporting analyses to CSV gives different output

We are currently migrating from OBI 10g to OBI 11g (11.1.1.6). In 10g a report has been made that contains a custom date format YYYYMMDD. This report is exported from OBI and imported to another system as CSV.

This report looks like:

The report looks like this:

(The first column is the format that has been changed to YYYYMMDD, the second column is the default format)

When the data is exported to CSV you get the following layout:

The date format has changed to YYYY-MM-DD instead of YYYYMMDD

When you include a column with DATETIME in the RPD you get the following output:

After a short investigation on MOS bug 9255767 was found. This bug is classified as an Enhancement, so I don’t expect a quick fix.

A solution would be to:

  • Create an extra column in the RPD of the desired format (YYYYMMDD)
  • Create a function in OBI to extract the year/month/day from date column

    Why are these basic functionalities (what you see is what you get) not proper implemented within OBI???

  • Posted by: michaelverzijl | 27/03/2012

    OBI 11.1.1.6 – Export to Excel

    20120529 – Solved by applying patch 14003822:
    http://mverzijl.wordpress.com/2012/05/29/obiee-11-1-1-6-export-to-excel-solved/


    OBI 11.1.1.6 is available since 1 month and currently we are installing this release by several clients.
    During testing we found a nasty bug in exporting an analyses to Excel.

    What’s happening?
    We have a dashboard that has a very simple analyses:

    When exporting this to Excel the result is:

    The decimal separator is shown with a “.”, instead of a “,”
    Therefore analyses don’t show a nice result in Excel as a Dutch system expects a “,” as a separator for decimal numbers.

    Changing your locale setting in OBI doesn’t do the trick unfortunately..
    Bug numbers 13886133 and 12931559 can be followed on MOS for fixes (hopefully soon because this is a show stopper for migrations to 11.1.1.6)

    Posted by: michaelverzijl | 26/03/2012

    OBI 11.1.1.6 – Page breaks not displayed on dashboard

    Last week I did an upgrade from OBIEE 10g to 11.1.1.6 on Windows 2008.
    The client has made some dashboard in OBIEE 10g with page breaks so that the report is printed on separated pages.

    Unfortunately OBIEE 11.1.1.6 (and earlier releases also) have bugs in displaying page breaks on Dashboards and exported pdf/html.

    I modified the sample app to show the error when using page breaks.
    The dashboard I will be adjusting looks like this:

    In OBIEE 11.1.1.6 you can create the page breaks like this:

    This will result in a dashboard page looking like this:

    As you may have noticed: the Target Completion Ratio and Monthly Trending are on a separate page (not visible at the dashboard)
    When you export the dashboard to a PDF, a second page will be visible with these parts of the dashboard.

    If you want to follow the progress of this bug, it’s 13830870 on MOS.

    PS: I do believe Oracle has better options available for these kind of reports, BI Publisher for example

    Posted by: michaelverzijl | 27/02/2012

    ODI 11.1.1.6 Working with Groovy editor

    One of the new enhancements of Oracle Data Integrator is a Groovy Editor.
    From the documentation:

    The Groovy editor provides a single environment for creating, editing, and executing Groovy scripts within the ODI Studio context. It provides all standard features of a code editor such as syntax highlighting and common code editor commands.

    Building interfaces through the ODI SDK was also available in previous releases, but you needed external tooling like Eclipse Editor for this.

    Once ODI Studio is opnend you can find the Editor on the Tools menu (Tools -> Groovy -> New Script):

    So what can you do with this editor?

    With this editor you can create scripts to populate the ODI repository. A complete SDK can be installed while installing ODI to your machine.

    In this post I will be using the Groovy Editor to create an interface between a source table and a staging table.
    Because I was unfamiliar with Groovy I did some research and used these sites:

    So before we start the script we need to import classes provided by Oracle:

    // Context operators:
    import oracle.odi.domain.topology.OdiContext
    import oracle.odi.domain.topology.finder.IOdiContextFinder
    
    // Folder operators:
    import oracle.odi.domain.project.OdiFolder
    import oracle.odi.domain.project.finder.IOdiFolderFinder
    
    // Interface operators:
    import oracle.odi.domain.project.OdiInterface
    
    // Interface helpers:
    import oracle.odi.interfaces.interactive.support.InteractiveInterfaceHelperWithActions
    import oracle.odi.interfaces.interactive.support.targetkeychoosers.TargetKeyChooserPrimaryKey
    import oracle.odi.interfaces.interactive.support.mapping.automap.AutoMappingComputerLazy
    import oracle.odi.interfaces.interactive.support.mapping.matchpolicy.MappingMatchPolicyLazy
    import oracle.odi.interfaces.interactive.support.actions.InterfaceActionSetTargetDataStore
    import oracle.odi.interfaces.interactive.support.aliascomputers.AliasComputerDoubleChecker
    import oracle.odi.interfaces.interactive.support.clauseimporters.ClauseImporterLazy
    import oracle.odi.interfaces.interactive.support.actions.InterfaceActionAddSourceDataStore
    import oracle.odi.interfaces.interactive.support.actions.InterfaceActionOnTargetDataStoreComputeAutoMapping;
    
    // Transaction operators:
    import oracle.odi.core.persistence.transaction.support.DefaultTransactionDefinition;
    import oracle.odi.core.persistence.transaction.ITransactionDefinition;
    import oracle.odi.core.persistence.transaction.ITransactionManager;
    import oracle.odi.core.persistence.transaction.ITransactionStatus;
    
    // Data set:
    import oracle.odi.domain.project.interfaces.DataSet;
    
    // Data store:
    import oracle.odi.domain.model.OdiDataStore;
    import oracle.odi.domain.model.finder.IOdiDataStoreFinder;
    

    For this project I defined 2 vars:

    // Define VARS:
    def project = new String("Staging") // What is the target project?
    def folder = new String("Source_1") // Which folder in target project?
    

    Just like the blog from Oracle, a file is created which specifies the interface/source etc:

    def file = new File('e:/interfaces.txt')
    def s = 0
    

    The file looks like this:

    INT_ORDERS,SOURCE,ORDERS,STAGING,ORDERS
    

    So now for the Real code:

    
    // Get default context:
    OdiContext context = ((IOdiContextFinder)odiInstance.getTransactionalEntityManager().getFinder(OdiContext.class)).findDefaultContext();
    
    // Get Folder:
    Collection odiFolders = ((IOdiFolderFinder)odiInstance.getTransactionalEntityManager().getFinder(OdiFolder.class)).findByName(folder);
    if (odiFolders.size() == 0)
    {
      println("Error: cannot find folder "+folder+" in project "+project)
    }
    OdiFolder odiFolder = (OdiFolder) (odiFolders.toArray()[0]);
    
    // Print default settings:
    println ("Context used = " + context.getName())
    println ("Folder for interface = " + odiFolder.getName())
    
    file.eachLine { line ->
            s++
            toks = line.split(",")
    
            if (toks.length != 5)
            {
              println("Error in input, line: "+s)
            }
            else
            {
              iname = toks[0]
              srcmodel = toks[1]
              srctab = toks[2]
              tgtmodel = toks[3]
              tgttab = toks[4]
    
              // Transactie:
              ITransactionDefinition txnDef = new DefaultTransactionDefinition()
              ITransactionManager tm = odiInstance.getTransactionManager()
              ITransactionStatus txnStatus = tm.getTransaction(txnDef)
    
              OdiInterface odiInterface = new OdiInterface(odiFolder, iname, context);
    
              InteractiveInterfaceHelperWithActions interactiveHelper = new InteractiveInterfaceHelperWithActions(odiInterface, odiInstance, odiInstance.getTransactionalEntityManager());
    
              DataSet dataSet = odiInterface.getDataSets().get(0);
              OdiDataStore odiDatastore1 = ((IOdiDataStoreFinder)odiInstance.getTransactionalEntityManager().getFinder(OdiDataStore.class)).findByName(srctab, srcmodel);
              OdiDataStore targetDatastore = ((IOdiDataStoreFinder)odiInstance.getTransactionalEntityManager().getFinder(OdiDataStore.class)).findByName(tgttab, tgtmodel);
    
              interactiveHelper.performAction(new InterfaceActionAddSourceDataStore(odiDatastore1, dataSet, new AliasComputerDoubleChecker(), new ClauseImporterLazy(), new AutoMappingComputerLazy()));
              interactiveHelper.performAction(new InterfaceActionSetTargetDataStore(targetDatastore, new MappingMatchPolicyLazy(), new AutoMappingComputerLazy(), new AutoMappingComputerLazy(), new TargetKeyChooserPrimaryKey()));
    
              interactiveHelper.performAction(new InterfaceActionOnTargetDataStoreComputeAutoMapping())
              interactiveHelper.computeSourceSets()
              interactiveHelper.preparePersist()
    
              tm.commit(txnStatus)
            }
    }
    

    So what have we done?

    We created an interface between two datastores with the default Knowledge Modules selected.
    Building default interfaces is now as easy as running a script within Oracle Data Integrator.

    A log file is also created

    context used = Development
    Folder for interface = Source_1
    Interface INTFC1 created
    

    Note
    I’m not a Groovy/Java expert so I’ve done my best. Tips? Please help me!

    Older Posts »

    Categories

    Follow

    Get every new post delivered to your Inbox.

    Join 119 other followers