-
Error to create RCU in the DB2 - [FMWGEN][DB2 JDBC Driver]Failed to access database
Hi people, I need a help. I can not to create DEV_MDS and DEV_BIPLATFORM schemas in the DB2 database. After input the database information in the below screen, this error appears: [FMWGEN][DB2 JDBC Driver]Failed to access database Someone managed to create schemas in DB2 database using the RCU? Thanks. Luciana
-
Unable to restart OracleBISchedulerComponent and OracleBIClusterControllerComponent
The error in the nqscheduler.log file is as follows: [2016-04-04T10:46:58.000-04:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: ee45b860] SUGEnterpriseCredentialRepository not initialized^M [2016-04-04T10:46:58.000-04:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: ee45b860] [68008]…
-
Value for ROWNUM in generated SQL doesn't match configuration.
The physical SQL generated by BI Analysis queries ends with 'order by c2, c3 ) D1 where rownum <= 300001', however, this value doesn't match our configured settings. Our configuration settings are: <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->…
-
OBIEE running sum Using Dashboard Prompt
Hi guys, I have a specific requirement which I'm not able to create using Dashboard prompts and column formula rsum() in criteria(not in pivot table) . For example, MONTH NO. ITEM SOLD rsum(items SOLD) 1 5 5 2 3 8 3 5 13 4 8 21 5 4 25 6 6 31 I've created the above columns in the criteria. And i have a Dashboard Prompt to…
-
How to display only level 0 members with evaluate function
HI, WE are using essbase as a data source. can some one tell me how can I generate level 0 members from the hierarchy With evaluate function? If anybody have proper syntaxes for different possibilities please provide me that?
-
Change the text for subject area access in obiee 11g
Hi , I would like to change the subject area access in OBIEE 11g. I tried to search custom messages but i could not find proper file to change. I have attached screenshot for reference. Please help me if anybody tried in past. Thanks Srinivas
-
Error install biee 11.1.1.9 in WinS2012R2 Patch not correct
Dear Experts I would like to share the problem I am facing when installing BIEE 11.1.1.9 for Windows Server 2012 R2. First this is the only operating system option that the client has. When installing I get the error in the document cataloged BIP 11.1.1.9 Installation Hangs On Windows 2012 R2 (Doc ID 2051904.1) == Applies…
-
Presentation variables are not working
HI, we are using essbase as a data source. we are using dashboards as a platform for all repoting purpose. For last 1 months all presentation variables are working as expected.Just recently stop updating in the report even after I click apply button twice.Basically old variable value(could be default value) is not updating…
-
bi publisher email delivery with # sign in the email address
Hi, anyone knows how to get this # sign at the recipients delivery list to work; currently it is giving error. (#BI_GROUP@COMPANY.COM) Has anyone have come across this and have a work around? Thanks,
-
Borders for two Views graph and narrative
Hi, I have a report, which displays bar Graph and narrative view on a compound layout. I need to bundle them together under the same border. but there is no option for that, I mean no borders etc are available for Compound layout . All I can do is separate borders around the graph and narrative on 3 sides each leaving the…
-
Custom text not displayed in the graph
Hi , I want to display a custom text and actual value from the database in the rollover of a graph. When i see the same data in the table view i was getting the correct result but when i rollover the graph, the custom text was not getting displayed. Is there any other way to do so ? ex : Column Formula : 'Country' ||…
-
How to test SMTP server
Hi Team, How to test SMTP server is working or not in OBI 11G because suddenly we are facing an issue that email has been not delivering to the mail box. Can any one suggest. Thanks in Advance,
-
Passing paramteres from agent to dashboard
Hi, I'm trying to create two Agents which should send same dashboard but with different parameters. I've tired to set request and presentation variable in conditional report (always true), but it seems that it doesn't recognize those variables on my dashboard. Do you have any idea to achieve that? Best Regards.
-
BI Publisher giving error for Before Report Trigger
Hi All, Can any one please help me on this. I have developed a report which triggers a package and populate data into a custom table, and that custom table is query on some conditions in the data sets in the report. While scheduling the report, its running and giving an error. Actually the before report trigger is…
-
Filter Criteria in MAD App in order to make fields dependent on other fields.
Hi, all, We have received a business requirement to develop several MAD apps, for which we were intially thinking about using Exploration (vs Navigation) pages. However, we are facing the following problem/constraint at filter level: Typically, users want to use the following fields for filtering purposes: - Year - Month -…
-
OBIEE 11g/12c - Passing parameters to a OBIEE session
Hi, Anyone know is there a parameter(s) that can be used to pass a value into an OBIEE session from a third party application? I need an additional parameter to set a content language for OBIEE reports from an integrated application. An good example of this is the &Lang parameter (which I'm using ) which you can set to a…
-
Urgent: Advice needed on RPD patching and Original Master Repository
I need the opinions of those who are knowledgeable about RPD patches. One of our consultants has said that we can apply a patch created using an old Original Master Repository, to a Production RPD that comes from a newer Original Master Repository, and that if the changes look like they are correct, then the patching…
-
OBIEE / Essbase Integration - Group By Values in Different Generations
OBIEE 11.1.1.7 / Essbase 11.2.4 I am creating a report with a bar chart to show some values of Revenue which will be grouped by Entity coming from the Entity Dimension. Y-Axis will have value of metric such as Revenue. X-Axis will show Entity such as Entity 1, Entity 2, Entity 3, Entity 4, Entity 5. My problem is that…
-
OBIEE hyperlinks and drill through
Hi all, I have a requirement as follows I have to navigate from a report to another using a hyperlink in the first report which points to the second report. The issue have column prompts in the 1st report (let month {M}), i have applied this column as prompted in my 2nd report. But 1 column is showing blank record in the…
-
Analysis Filter for sales past in time, but current inventory
Hello, I have a requirement to display some information for a given date in the past, which works fine. The requirement shifted to show always the *current* inventory metric. I am doing this with a column filter(inventory using date = today) formula, but the analysis filter restricts the data set. Is it possible to do…
-
yearly revenue, but from 2006-2015, he wants to see the whole sum revenue, how we do that.
HI all If a report contains years from 2000-2015. the client wants to see the report from 2000- 2005, yearly revenue, but from 2006-2015, he wants to see the whole sum revenue, how we do that. ....................... Another Reqirment .. if We have a multiple reports on dashboard, But the client doesn't want to see the…
-
OBIEE & Essbase Security Integration
OBIEE 11.1.1.7 / Essbase 11.2.4 We are using the EssLoginAs API out of Essbase to impersonate an Essbase user in OBIEE and utilize the existing data filters created in Essbase within OBIEE reporting. In the connection pool in the repository we have enabled "Shared Login" and "SSO" for the WebLogic user. When creating a new…
-
"page options " option is not displayed on user dashboard in Obiee 11g
Hi Experts, user getting issue with "page options" on dashboard : user unable to see (not displayed) "page options" on dashboard in Obiee 11g (11.1.1.7.150120 ). Previously he was able to see, but after upgrading to R12 , he is not getting that option. i tried this below solution : Delete the user folder from the Catalog…
-
Missing cube Schemas when using OLAP plugin in OBIEE 11.1.1.7
Hi All, Recently our Database was upgraded to 12c And we are seeing an missing AW schema objects while importing from OBIEE Admin client tool in Win 7. Earlier we are on 11g version where we did not encountered any issue in importing cube objects in OBIEE.please let us know is there any patch or any configuration setup to…
-
Answers to essbase cube
hi, we are using essbase cube as a source in my report. in one of the report, evaluate_aggr function is using like below. evaluate_aggr('(Electronics)/*%1*/',product.product Name) we are using above logic in 'edit formula' of revenue column. tthis column is returning revenue for 'Electronics'. Can any one tell me how Obiee…
-
OBIA rpd upgrade from 7.9.6.3 to 7.9.6.4
Hi Team, We are upgrading OBIA from 7.9.6.3 to 7.9.6.4. We are currently using Project Analytics from the OOB rpd and rest of them are customized in our project rpd. Here are the steps I am taking to upgrade the rpd. 1. Extract Project Analytics from 7.9.6.3 OOB rpd (A). This also give Usage Tracking SA after the extract,…
-
OBIEE Web Services
I am trying to call OBIEE web services from SOAPUI, via the callProcedureWithResults() method. I have successfully made a call to the GetOBISVerion() method as follows: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://ws.admin.obiee.oracle/"> <soapenv:Header/> <soapenv:Body>…
-
How to Add Legend to Graph view through Java script.
I have a Graph, but I do not want to use its legend as it has much of text which is not business requirement. So, I created a legend with the requirement. I want to add this legend into the graph view using javascript. I can add it below the graph but the problem is Graph has a border and if I add the narrative text below…
-
OBIEE BI Server 12C "nqsserver.exe has stop working"
I have installed OBIEE 12c in Windows Server 2012 R2 Essentials. Initially it was working fine. I used to upload RPD and created reports. After few days when I stop and start services, I am getting error like "nqsserver.exe" has stop working. I go through the Google and I didn't find a correct solution. After that I upload…
-
OBIEE 12c - Cache - Not working
Working on Windows 2008 Server with OBIEE 12.2.1.0.0 My NQSConfig.ini shows ENABLED = YES for the caching option. (Actually, it shows all of the defaults, because I haven't changed anything.) All of the tables in my repository have caching enabled. However, there are no entries shown when I look at 'Manage ~ Cache' in the…
