It has been awhile, I think a year now, since my last blog. It has just been a very busy past year. In any event, I came across a problem that involves presentation hierarchy columns. The ever-beloved new feature of 11g , which all users and clients love to use for pretty much all reports.
The issue: How to create a navigational report which will filter the presentation hierarchy column based on the selected record from the calling report? This is otherwise known as report navigation via action links.
During RPD migrations we constantly need to change metadata for the target environment such as physical connection pool(s) and LDAP source(s). To do this manually is time consuming and open for error. Thus, there needs to be a way to script or automate this process. This document will address the automated solution using what is termed in OBI as the patching process.
There seems to always be the occasion where you want to create a report, which will need the use of selection steps to include all the available members; but you want to override the values to keep/use with those of a dashboard prompt. Currently, as of 220.127.116.11, the UI does not make it easy enough to do this. As the Start with all members dialog does not have the Override with prompt checkbox; like, the Start with selected member does. Nor does the Start with selected member option have the ability to specify or check you want all members. So you have
Problem and challenge came up recently to pull and set a multiple value parameter from OVD (or LDAP source) and set session variable (row-wise session variable to be specific) to be used by report writing. Well in OBI 10g, I usually have done that by using my custom LDAP table function to use along with setting row-wise variable(s) in an init block. I looked to see if anything has changed along the lines of accessing LDAP data sources and pulling parameters. There is no problem pulling scalar parameters and mapping them to session variables, only when it is comes to trying to pull multi-
Thought some developers may find this useful and save time trying to work around, fix or look for answers. Users of the latest OBIEE 11g release 18.104.22.168 may get this error going against OLAP source systems.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A
general error has occurred. [nQSError: 43113] Message returned from OBIS.
[nQSError: 22068] No more than 1 hierarchy from the same dimension Instrument
can be referenced.
The current global go script I have not only produces one ‘go’ button for all prompts on a page; but, it also has code to create required fields and required field validations. The one thing that was brought to my attention was that my current script treated the prompt collective on the page to have dashboard scope. To read about prompt scope, read here. So whether or not you had one or all set for page scope the global go button disregarded and made it act like dashboard scope.
Some may think that the scope of the prompts do not work and are broken; but, they do work and are not broken!
How does the Dimensions get their ROW_WID(s), which are the dimensions PKs? Well it is not done by the database systems. Instead, the PKs are controlled by Informatica using Sequence transformations. These Sequence transformations are within the mplt_SIL_XXX(s) within the SIL mappings. Remember in my prior post on mapplets defined in OBIA, these *_SIL_* mapplets are used for lookups for any FKs for the target table and also for getting and setting the PK(s) or ROW_WID(s). These mapplets are usually after any filter transformations and before the update strategy transformation within th
There are pretty much 4 predominant types of mapplets in OBIA Infa ETL.
Business Component (ex: mplt_BC_XXX) – These mapplets are used to extract the data from the source systems. They are only found in the SDE folders and start off the majority of the mappings. Within these mapplets, you will find the Source Tables and the Source Qualifier, which has the SQL Overridden. Some SDE mappings might not use these and have the Source(s) and Source Qualifiers straight within them.
Just came across this one today. This appears to be only in v22.214.171.124 as I have not seen before. Here is the snippet of error message from DAC:
2011-05-12 08:43:50.358 INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD:(Source : FULL Target : FULL) has started.