-
OBIEE Query Performance degrades when using synonyms
Hello All, I have 2 schemas(say Schema1 and Schema2) where, Schema1 has the actual table and Schema2 has a synonym for the table created in Schema1. For example, I have a table Schema1.Tbale1, then it has a synonym in Schema2 as Schema2.Table1. When trying to generate a direct database request from analyitics using the…
-
how to invoke java beans on oracle EBS form
how to invoke java beans on oracle ebs form
-
Always Display default values in pages with action links
I have multiple pages in one dashboard. i Set prompt scope to 'Page' in all pages. As per requirement , I need to create links(action link) for other pages In first page. ccurrently if I navigate from first page to second page through action link, all prompt values are passing from first page to second page. my requirement…
-
One line for labels in Stackbar graph in OBIEE
Hi Gurus, Need urgent support from you!!!! My client requested for stacked bar graph, which on the horizontal axis has two labels (text format). Depending on the values selected on prompts, these labels could be presented in one, two and three lines. Now, the customer requires to have these labels in one line at ALL THE…
-
Unable to export the report as a normal user
Hi Experts, I am facing the issue , I am a admin user I can able to export the report in to excel. but as a normal user he is not able to exporting the report in to excel. Can you help me where I need to check the permissions for this. Is there any specific permissions I need to apply. Thanks in Advance!!
-
OBIEE Export to Excel issue - Leading space not getting exported to Excel/PDF
There is a Leading space in data (for Ex ' abc') and is displaying correctly in dashboard but when we export it to PDF/Excel, the leading space is trimmed Off. I want to preserve the Leading space as well while exporting. I am currently using OBIEE 11.1.1.7.151020. It looks like after the recent patch upgrade from…
-
Apply filter on hierarchical column with selection steps
Hi, i need to pick only certain rows from the hierarchical column EX: A is the parent in the hierarchical column B and C are children to A D and E are children to B F and G are children to C and so on My requirement is to pick rows A,D and F. So in selection steps I keep only A,D and F to display in the report.But the…
-
Installation Question (OBIEE 11.1.1.7 + OHS)
Hi all, Bit of an urgent one here. I've been planning an installation for a couple of months now which is said to go ahead this weekend. The plan is to move our OBIEE installation from a virtual machine to a physical box with far more grunt. Unfortunately, because they'll be running different OS's, cloning wasn't an option…
-
Unicode Apps
Hii .. Any one has any case study on Unicode apps .. how client can benefit out of it... Thanks
-
OBIEE Upgrade from 11.1.1.7.131017 to 11.1.1.9.0
Hi all, We are trying to upgrade OBIEE from 11.1.1.7.131017 to OBIEE 11.1.1.9.0. During the upgrade as per Oracle doc we were successful in WLS upgrade from 10.3.5 to 10.3.6, software only installation of OBIEE 11.1.1.9.0, psu.sh execution to upgrade the MDS and BIPLATFORM schemas but while executing the config.sh the…
-
Asset reports derivation
Hi all, We have to develop a Asset report for this there are some dervied columns like cash and cash on balances are present , these are based on some accounts in GL so where can we write the logic for these in BMM layer, each column we have to use the case when and derive the value or any other approach? Thanks in advance…
-
Show User GUID for all user
Hi, I have question, because I created scorecard and If i see the scorecard properties there is someone who is editing scorecard (CurrentEditedBy). This number is User GUID. Is it possible to view all User GUID for all users?
-
Analysis description as tooltip - limitation.
-Hi, When I add a comment to Description property of an Analysis, I can see the comment as a tooltip. However this is only valid when the Analysis' title is included in the compound view. If the title view is not included in the compound view or on a section we select only a table view (e. g.) then the tooltip can't be…
-
authentication using two different AD authentication providers (2 separate domains)
Does anyone have a working installation of OBIEE 11 using AD authentication with 2 different domains, implemented as 2 different AD authentication providers in the WebLogic console? We have some users who are members of domain "A" and a secodn group os users, members of domain "B". Our system works correctly against for…
-
Column Properties Doesn't open up
Hi All, I am on OBIEE 11.1.1.7.0. When I click on column properties, the column properties doesn't open up. Please help me out. Thanks, Deep
-
OBIEE Authentication Through OFFICE 365
Hello Experts, We are trying create a scenario where a user logs in to Office 365 and he gets authenticated in OBIEE as well. He doesn't has to go through one more authentication to view OBIEE Dashboards. I wanted to know if this can be achieved, if Yes can i please get steps of how to configure it. Thanks,
-
Error while scaling out
I am trying to scale out my server horizontally. I have created a shared folder for rpd and catalog. Everything works fine till this. But when i try to add system components at EM -> coreapplication -> Capacity Management -> Scalability, and restart the services, i am getting following error. Command failed: Instance…
-
OBIEE 11g OPMN Issues
Good Morning all All the best for 2016 i hope this will be your year of great things. Iam facing an issue when trying to Start OPMN from the Linux back end. Please see the error i am getting when trying to execute opmnctl startall [2016-01-07T10:10:50+02:00] [opmn] [ERROR:1] [] [internal] lxlinit - NLS boot file not found…
-
Reuse 5 dashboard pages bundle in multiple pages
Hi, I have one dashboard and that has 5 pages. My requirement is need to create Links for all pages from the active opened page (report). Ex: let's call dashboard name as D and page names as P1,P2,P3,P4,P5. Dashboard D has 5 pages (P1,P2,P3,P4,P5). Suppose If I open P1 in D, I want to see links for all reports with links…
-
How to Pivot the record and dynamically include the columns
Hi, Am BI resource and new to Oracle. I have a requirement to create a view for reporting. 1.png 2.png 3.png View column template is attached. Product and Item level records are stored in row level in DB tables. But for reporting, I need to display the Product and Item level at Column level (From column E) and based on…
-
Question about a LOAD with table with XMLTYPE field
How can I load a table with an XMLTYPE field. When the mapping is executed, it shows me this error oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLException: Invalid column type: 1111 at oracle.odi.runtime.agent.execution.sql.SQLCommand.bindResultSetColumns(SQLCommand.java:280) at…
-
Writeback Error
Hi, I am using OBIEE 12.1.2.1 and implementinh writeback, I have followed the steps to configure as outlined below https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG9156 When attempting to insert a record in the analysis I get the following error The system is unable to…
-
OBIEE 12c: Tnsping Utility Executable On Solaris Zero Bytes
Do we have steps for Solaris OS similar to Doc ID 2181368.1 tnsping utility is of zero byte on solaris OS as well. OBIEE 12.2.1.3 Thanks in advance.
-
Calling BIP report with hyperlink issue
When customer use the hyperlink to navigate to a address like "baidu://message/?sid=&&id=DS_1207" in rft. The address was changed to "file:///u01/oracle/config/mserver/bi_domain/baidu:/message/?sid=&&id=DS_1207" when view the report. Tried to create a form field as below: <fo:basic-link…
-
BI publisher Add jdbc datasource is not working
Hi All, jdbc datasource was working fine. Suddenly jdbc datasource is not working properly. When i try to open the existing jdbc datasource. It is not opening. When i try to add a new datasource. Even add jdbc datasource is not working. Somebody has face this issue and anybody has any idea. Please assist. BI publisher --…
-
Create insight in Visual Analyzer for Oracle Business Intelligence 12.2.1.2.0
I cannot create Insights in Visualizer analysis VA projects. Once I created the insight, some of the old data is deleted Please could you help?
-
After ssl configration ,usage tracking configration ,analytic cant login ,always log in loading
OBIEE12c version:12.2.1.2.0 ssl configed referance for https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=531849997213523&parent=DOCUMENT&sourceId=2244478.1&id=21… usage tracking referance for Welcome to OBIEE12c - Set-up Usage Tracking – Part 1 - Red Stack Tech I patched 24967379 and 25853222 before config…
-
Is the Interactive Reporting Translation Workbench Utility still supported by Oracle?
Have been searching and cannot find information to determine if the Interactive Reporting Translation Workbench Utility is still supported by Oracle. Thanks! (I reviewed Oracle's Lifetime Support Policy doc but could not find a reference).
-
How to call Static variable in CustomLink.xml file in OBIEE11G
Hi All, Recently we have upgraded for OBIEE 10g to OBIEE11g. In 10g we have created custom links using by calling 'Static Variables' in commonuitemplete.xml. If i call same variables in 11g customlink.xml it is working.Let me know if anything is wrong in the below code. Code: <locations> <location name="header"/>…
-
How to make a Text in RTF a hyperlink and pass a dynamic URL link from .xml
Hi, I need to create hyperlink in rtf which has a dynamic URL link generated from .xml file. In my RTF, I will place a text called, click here to view the output (its a pdf) and when you click the link, it generates a URL from the dynamic sql written in data template file. Sample on page 3 in the rtf attached. Please…
