-
Hide dasboard page
Hi, I am using OBIEE 12c. I have two dashboard pages ,one for prompts and the other one for report and i want to know is there a posibillity to hide dashboard page where my report is until I hit apply button on previous page where my prompts are? Thx, Matija
-
OBIEE 12.2.1.4 Forbidden characters
We have a few analysis that contain EVALUATE_SCRIPT formulas that reference .xml files that are located within our OBIEE catalog (for example: EVALUATE_SCRIPT('filerepo://../../../../service_instances/ssi/metadata/content/catalog/root/shared/obiee%2eProj%2exml). These worked perfectly in 12.2.1.2 and 12.2.1.3, but when the…
-
Drilling down from Analytics Page to Siebel and Then Back
We've got an issue with the integration between OBIEE and Siebel open UI. In the dashboards we are using action links so that we can call Siebel records from links in OBIEE dashboards. When we want to go back from the Siebel record to the dashboard we use the "back" button in the browser. This used to bring us back to the…
-
Unable to setup a obiee DSN on windows to connect to Oracle Linux 7 based installation of OBIEE 12C
Hello All, Since last couple of days i am stuck with one of the major (but of course for you all not big issue as i am new to this section) problem while setup of System DSN on my windows system. Requirement:: I have installed OBIEE 12C version on my Oracle linux7 desktop at office work. Everything is working fine here and…
-
ClientSessionExpireMinutes Does not Work (Obiee 12c)
Hello, I am trying to change obiee login time. That is, when I log in analytics side, after 5 minutes the connection should be disconnected. When I searched it on the internet, I found following ClientSessionExpireMinutes parameter to change. However, it does not affect anything :S I also restart whole server after change.…
-
Add new style for COLOR in MAP edition (color fill)
Hi everyone, Oracle Business Intelligence 11.1.1.7.140415 Can anyone tell me where can I add new default color-style for color fill in map edition? I show you screen: I want set default colors for every my layers on map - I have some documentation from client about this. Maybe can I add and change this in some file on BI…
-
How do I avoid blank page in BIP Report?
Summary BIP Report prints a blank page when trying to print a subtemplate. Content I have a requirement where I need to print a sub template based on a condition in a RTF template. Output is in PDF format. My main template is in Landscape mode while the sub-template is in Portrait mode. I need to have a page break between…
-
OTBI Top 50 poor performing Reports
Summary OTBI Top 50 poor performing Reports Content Hi All, I am trying to find out reports that are performing poorly in our environment. I am running analytics and reports in oracle fusion cloud (OTBI/BIP) R13. I am looking for list of : - Report name with path - Runtime - Execution time and date For the past two months…
-
Error creating an OAC instance
Summary I get the Error PSM-BOOT-01009 DNS lookup failed for expected service hostname. Content Hello, I try to create an instance of OAC, all the validations are correct, but I get the error: 04-sep-2018 16H13' UTC Started operation to create service [SENASICAOAC1] in identity domain…
-
nested table on bi publisher
Summary nested table on bi publisher Content Hi, guys I want to make a report with bi publisher, on my template I want to make report like this : so I make a template like this : But when I'm compiled it , it comes to be like this : It's different on my report, so what I must to do to make report like that. Please help me…
-
OBIEE12: Problem to create an (dense)analysis with a logical SQL
Hi, I need to create an analysis and I want to make a dense extraction to display all rows of a dimension. I could do that within the repository design but this decrease considerably the performance. Ive written a logicial SQL that does the trick and this SQL works perfectly within the Issue SQL in administration panel!…
-
Presentation Variables in Title Views and Filters
I'm designing a new dashboard, and I'm having trouble finding information for my specific issue. There are three values that the users are prompted for: Federal Fiscal Year, Type, and Contracts. The particular prompt I'm looking at right now is for Type. I looked into bins, but my understanding is since my groups have…
-
BI Publisher - help
Hello, I'm stuck in one of the issue in BI publisher. Actually its not an issue, but trying to find solution not sure its possible or not, hence posting here for your inputs. I have a BI publisher report (xls template) which generates report in xls. Users have option to run it for level 1 and level 2. There is one section…
-
Catalog Manager in Kerberos SSO environment
Hi All Our OBIEE application (12.2.1.4) is configured using Kerberos SSO along with AD. How to connect using weblogic user from the catalog manager tool? I have tried using the link http://hostname:port/analytics-ws/saw.dll using the weblogic credentials but am getting the following error Client received SOAP Fault from…
-
Using Current_Date to Create Financial Year Quarters
Hi all, I am running this SQL in SQL Developer and it gets the results as I expected. I want to generate the same thing in OBIEE column formula 12c Version which returns the value in Financial Quarter. All I am trying to display the number of financial quarters to date in financial year. Select Case when trunc(sysdate)…
-
In report data need should show in single row
Hi Everyone, i need help in Modeling RPD or report. Below is the table structure which gives Current tier, End of last month, End of last month previous year. i modeled it in Logical layer, by using case statement. (Case when Time_period='EOLDM' then Tier_name end) which gives me EOLM Tier Name. same way for current and…
-
Inline Cell commenting
Hi We have a requirement to add cell commenting on the reports of OBIEE 11g. The user should be able to add comments and save it at run time without using the write back feature. Is there any alternative method to implement this feature ? Regards Vyshak
-
OBIEE and WFS Theme - Layer key is missing
Hi all, have somebody experiences with WFS themes and OBIEE? I create a WFS theme in MapBuilder, then I can import it in OBIEE as a new layer, but I cannot find any setting to get the “Layer Key” in OBIEE “Edit Layer”-window. Is it even possible to use WFS themes and OBIEE? I cannot find any documentation nor MOS Note nor…
-
Multiple ERROR DVD
Summary Error Running Data Flow nQSError: 46105 Content I get this error when running a data flowDoes anyone know how to correct it?[nQSError: 46105] Error al ejecutar el proceso: "C:\Program Files\dvmlruntime\Python-3.5.2\amd64\python.exe"…
-
State: HY000. Code: 46008. Internal error:
Summary Query Error for vizualizations Content Hi All, I am getting a query error as tate: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000) State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000) State: HY000. Code: 46008. [nQSError: 46008] Internal error: File…
-
OBIEE 11g admin tool(client) installation on windows 10 fails
Hello all, Hello All, I tried to install OBIEE 11g admin tool(client) on windows but i am facing an error. below are the error details. Tried with changing compatability mode and run as administrator but still facing the error. Pls help
-
Working Example of updateReportDefinition soap request
Hi all Is there a complete example of updateReportDefinition soap request? The requirement is to update the path of data model as well as other report details like style template etc. regards Zulfiqar Haider
-
Conditional formatting in Pivot table OBIEE 11g
Hello, I am creating a pivot table using union query and created a calcualted field ratio for the pivot table ($1/$2).Now I need to apply the conditional formatting on the Only the Ratio Field something like if the ratio is <10 show the metric in red color. Please let me know how this can be achieved. zip code metric1…
-
Different formatting every time you open report in BI Publisher
Summary What makes the formatting done in .rtf template change every time you open report in BI Publisher? Content Hi. I am creating reports in BI Publisher using .rtf templates and noticing that often when I upload the document to BI Publisher, formatting is wrong. Wrong in a way that distance of header from the top…
-
Scaling and Load balancing..
Hi, Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production OBIEE 12c, ODI 11g.. We have a Reporting solution on (stack) OBIEE/ODI/Oracle-DB/Linux. Currently this solution is enabled only for one region. There is a requirement from the business to enable this solution to other regions as well. The…
-
BIP Report Bursting with XML source
Summary BIP Report Bursting with XML source Content Dear Group Member, I am having an XML source with more than 2.5 GB size having data of more than 50 thousand user. Have to implement bursting but Oracle BIP bursting is supported for only SQL Type not for XML. That XML data contains complicated business logic and its very…
-
Printer associated with Fusion
Summary Can no longer print to printeres linked to Fusion after R13 upgrade Content We have two printers that are specifically defined with the Fusion application. We do not use a Print Server. Validation and Certs are resident within the printers. We are experiencing issues with printing to these particular printers after…
-
Different formatting every time you open report in BI Publisher
Summary Report layout changes every time you upload report to BI Publisher Content Hi. I am creating reports in BI Publisher using .rtf templates and noticing that often when I upload the document to BI Publisher, formatting is wrong. Wrong in a way that distance of header from the top margin is different than I expected.…
-
BI Server Component from OPMN Services is not UP after restarting the services
Hi Team, One of the component in OPMN Services the BI Server is not up and running when we try to restart the services. No error details is showing in nqquery, nqserver log files. Any clue? Regards, Kumar.
-
Unable to load region in iframe in OBIEE dashboard
Hi , I have an ADF Application as a dashboard region in OBIEE.. It is working fine in the iframe inside dashboard having URL as localhost:portnumber. When deployed in server having hostname , the region is loading inside iframe for the first time. When u navigate to different page other than ADF page and navigate to ADF…
