-
Many fact tables in one BusinessModel
Hi all I have now many fact tables in one BusinessModel. There are: Distribution, Payments, Action (and many common entity joined with facts) I understand that best way to do 3 BusinessModels - one model with one fact table with all other entity, to do 3 star schemas but what to do if business user whant to join all…
-
Metadata load to Essbase ASO having Allow Duplicate Members option enabled
Summary ODI unable to load the metadata to another dimension having same member / alias names which other dimension have in ASO cube Content - I am loading metadata to an ASO cube (ESS_REP) for which I have enabled allow duplicate members option. - The source of loading metadata is another ASO cube (CRAv1R) - I created ODI…
-
How to change rpd metric
I am trying to get a count of some active flag for an event at the rpd level, currently I am using SUM as the default aggregation rule, but I wanted to use something like this ( SELECT DISTINCT JOB_NAME, INT_ID, A_CAN,O_NAME, P_NUM FROM WC_XYZ GROUP BY JOB_NAME, INT_ID, A_CAN,O_NAME, P_NUM ) the reason Is that the source…
-
OBIEE Union report having issues
Hi, I have a union report with two instances and first instance calculating based on cob date and second instance calculating difference b/w cob date & comparison date. Issue: Suppose if I don't have data for cob date and have data in comparison date then in both the tables it's picking comparison date data. But my…
-
nqsserver crash
Recently upgraded from OBIEE 12.2.1.2 to 12.2.1.4. Downloaded a number of patches as part of the upgrade as there are so many disconnected parts which have not been well bundled in this upgrade. Down to the last few errors to resolve. a) nqsserver crashes as soon as I try accessing data from planning data source. Does…
-
OBIEE 12.2.1.3.0 do not see create "new folder" option under "shared folders" of catalog
Hi Gurus, i am on OBIEE 12.2.1.3.0 and signed into the analytics with a user ID which has BI Author, Consumer and Admin privileges. When i tried to create a new folder under "shared folders" i don't see "new folder" option under the main "NEW" menu on the top. But i can see all other options like analytics and interactive…
-
Upgrade OBIEE11.1.1.7.150120 to OBIEE 11.1.1.9.x
Hi Experts, How to upgrade from OBIEE11.1.1.7.150120 to OBIEE11.1.1.9.x, will we get direct patches moving from 11.1.1.7.150120 to OBIEE11.1.1.9.x. Could you please share your ideas. Thanks in Advance!! Sree
-
Custom Landing page in OBIEE 12.2.1.4
Dear GURUS, I am trying to create a custom landing page for all the users who are logging into OBIEE. OBIEE Version is: 12.2.1.4 I am following the "OBIEE 12c : How To Use Session Variable PORTALPATH? (Doc ID 2215294.1)", but am not clear about Step 9 from this post. It just mentions to do the below changes: " Select Data…
-
How to get the date formant in RTF Template
Summary need to bring date formant in rtf template. if i take sysdate i am able to see the data whereas parameter date is not showing in rtf template. Content Hi, need to bring date formant in rtf template. if i take sysdate i am able to see the data whereas parameter date is not showing in rtf template. can anyone let me…
-
OBIEE 12c -OCIEnvNlsCreate or OCIEnvInit failed to initialize environment.
Hi Friends I am facing a problem while running an Analysis in <host_name>:9502/analytics. I am able to see my subject area and pull the columns but when I click on the Results I get an ODBC error. The error says: [nQSError: 17002] OCIEnvNlsCreate or OCIEnvInit failed to initialize environment. Please check your Oracle…
-
Catalog conversion from 11.1.1.7 to 12.2.1.4 issue
Hi, converting the catalogs from 11g to 12c all the pivot table's attribute value fonts are turned Bold across the board, is there a way to fix it without individually editing each pivot report ? Any input is highly appreciated. Thanks,
-
Oracle BI Data set_Data Source
Hello, I can't find, within Oracle BI Data base (Cloud edition) some fields corresponding to OTM data base field (for example i can't find the equipment_ref_unit_gid inthe BI Data base ) ! Is there a way to customize to mapping between the two data base (BI data base and OTM data base) , and can we execute SQL queries the…
-
Set a repository variable with a multi value presentation variable
I've a dashboard prompt which has 2 presentation variable prompts(say X and Y), out of which variable X accepts a single value and Y accepts multiple values. I'm using a few session variables at the RPD level which I need to override with repository variables. So, in the report, I'm using SET VARIABLE…
-
OBI - Could we use an Agent to schedule a report to send to SFTP server on Cloud?
Summary OBI - Could we use an Agent to schedule a report to send to SFTP server on Cloud? Content I have an assignment to schedule the report using an Agent to send to SFTP server. Most of the reports were scheduled to send to specific email addresses. most the document I read it has to be done on the window server; I am…
-
Multiple Calculated Measures
Hello, I have a need to display multiple calculated measures in order. The logic behind them is simple - If condition met then display value. However when the values are displayed they create an additional row in the report. Is there something that I am missing to prevent this from happening?
-
PO Report - How to bring Blanket purchase agreement column using SQL Query in BI Publisher
Summary Need to bring Blanket Purchase agreement column in BI Publisher report Content Hi, I have PO Report and need to bring Blanket purchase agreement column in Bi Publisher PO Report. which tables i need to join to bring the balnket purchase agreement number. can any one help me how to get that column in sql query.…
-
Admin user permissions problem
I inherited an OBIEE environment that when logging in with the Administrator user I don't see the "Permissions" icon for any of the folders or objects. When copying an object, the "Paste" button is greyed out I can edit objects and/or create new, but if I try to save in any of the folders I get "Access denied to user to…
-
Installation check vs Certification Matrix
When upgrading to OBIEE 12.2.1.4 from 12.2.1.2 with a patch, a redy check is included. But how does it different from the certification matrix. Can you assume that the redy check on the installation is enough to get all functionalities?
-
How use metrics from two facts table on same report
Summary Same report two fact tables Content I ma working on requirement that requires me to use metrics from two facts tables, however when u use the metrics on same report, my expected results are getting inflated. I realize its possible because the two fact tables are not joined. Any suggestions on how I can possible…
-
OBIEE Analysis SQL Statement
Hello, First some background - I'm converting Hyperion reports to analyses in the presentation layer of OBIEE 12.2.1.2.0. I do not have access to anything except the presentation layer. I'm wondering if something like the below SQL example statement can be used anywhere in the presentation layer of OBIEE: TABLE.COLUMN =…
-
Cloudera Impala Kerberos connectivity Error on OBIEE12c in Linux server
Hi Gurus, We are facing an issue to connect from OBIEE12c ( Linux Server) to Cloudera ODBC driver for impala using Kerberos connectivity. Issue Details : cloudera odbc 10380 unable to establish a connection with data source. Missing settings: {[HOST] [Port]} [Cloudera] [ODBC] (10210) Attribute identifier invalid or not…
-
Drill down using Action links to detail report based on one column and also want to pass master-deta
For example I have Master report with Columns A, B and C. master detail is enabled on column A. I want to drill down to child report based on column B and this has to pass Values chosen in Column A and B to child report.
-
Obiee Patch Question
Hi, Today, I try to update obiee system versiyon with the following bundle patch. I read "Read Me" file line by line and completed all the steps. All the steps were successful. I get "Opatch succeeded" messages. However, when restart the system, version is not changed :S I did not understand what I missed :S…
-
BI Publisher FTP Issues
Summary Not able to FTP a file from BIP server to FTP server. I am not able to add the Server name as well as I have tired using Bursting. Content Hi, I am working on BI Publisher FTP server setup. The FTP Server is a FTPS on DMZ domain. And it seems like Oracle supports only SFTP. Good news is that, I am able to connect…
-
Can BI Publisher Enterprise on-premise connect to Fusion ERP Cloud?
Summary Can BI Publisher Enterprise on-premise connect to Fusion ERP Cloud? Content Hi All, Is it possible to point at Oracle ERP Cloud (SaaS) as a data source from an on-premise instance of BI Publisher Enterprise? Thanks, Richard
-
Strange user id in OBIEE "wso3y1vgnp65ehfzrl8jiaqmtukxdbc2" not mine
When i use "Manage Sessions" in OBIEE, user info appears. But there is an odd user information that is generated. "wso3y1vgnp65ehfzrl8jiaqmtukxdbc2". Is there anyone who has encountered the same problem?
-
Obiee General Problem
Hi, Yesterday, we restart the obiee server machine. After restart, for some obiee queries following error occurred. But not all the times, some times. Also, not always the same query. It changes time to time :S Error details; [nQSError: 17010] SQL statement preparation failed. [nQSError: 17001] Oracle Error code: 3113,…
-
BI Publisher creates newline in RTF output
Summary Empty newline generated after sentence in table row Content When I export document from BI Publisher as RTF, it creates a newline after each sentence written in a table row. I have to manually erase it. Why is that so? The height of row is 6 mm and exact. It doesn't work with setting the height to 'At least'…
-
BI Publisher Dynamic image
Summary Dynamic image is not changing in the PDF Format Content I am trying to achieve dynamic image on the PDF Report. XML Tags are generated correctly with the right image name but the first image is repeating for all the remaining all the pages pdf. Please advise how to reset the image after the first page completed.…
-
How to add a feedback comment from OBIEE
Hi All, I need to add a comment from the OBIEE dashboard where it will be updated in the DB and in the next time view the comment can be retrieved in the Dashboard. Is this possible in OBIEE and if so please advise on how to do this. Unable to use any third party API's of plugins due to security issue in my organization
