-
invalid syntax filter count
Summary invalid syntax filter count Content Hi people! In my BICS analisys I'm trying to do a conditional count in a column formula, but, the column formula edition box returns me "invalid syntax" or a wrong result for the formula in the pivot table. I need to count "senhas" that is a alpha numeric data that represents a…
-
Want to be heard by Oracle, speak in unison!
To all who want a vote in the future shape of Oracle BI, please see my idea above and upvote! thanks!
-
RPD - Model a LTS table source to only be used for a subset of customer ids - 12c
Our RPD model uses many aggregate tables per LTS for performance and routing reasons. Those aggregates are rollups or detail so the model satisfies "routing" for the a combination of fields to the right table. We also use the Priority Groups in the LTS fact table to further guide the black box behavior. I now have 2 tables…
-
Images are not viewed on my custom report. BI Publisher.
Summary Images are not viewed on my custom report. BI Publisher. Content Hi there, I have a problem with BI Publisher I hope you can help me. So,when I'm trying to print my own custom report, images are not printed on this report, it only shows the images' name. These images are entered into a busisness process on…
-
BI Publisher 12c Error : Failed to load xml in Data model (view data)
Summary BI Publisher 12c Error : Failed to load xml in Data model (view data) Content Hi All, I am trying to create data model using simple sql query (configured JDBC connection) and when I am clicking the view data ,am getting error as "failed to load XML " due to this I am unable to create report and was not able to…
-
PDF Preview failing when an IMAGE is pasted onto the RTF Template !!
Summary PDF Preview failing when an IMAGE is pasted onto the RTF Template !! Content Hello All, We have a report where in two pages of the template have two images. When I insert any of the image, the PDF preview Fails giving the Below Message. Can someone suggest any idea ? P.S: Its a Full Page Length Image and NOT like a…
-
End of the Report in RTF Template
Hello, I have created a RTF Template and placed the "End of the Report" Text at the end of the template after all the loops and tables and everything. It is not printing. Can you please suggest what mistake I am doing. or can you please let me know how to do it. Thank you,
-
obiee v12 - "too many running queries"
Hello, we've experienced "too many running queries" error since last week intermittently. Weblogic has no stuck thread, so we presume it's a db issue. The only solution we've found out is to restart BI services. I've some questions for you: - Is there a way to check which are the current running queries? In this way i…
-
BI Publisher "X" for graph data
Summary BI Publisher "X" for graph data Content Using a query, we open OneView Reporting - BI Publisher - And attempt to make graphs. When doing so, some data appears in separate columns under "XXX" as seen in the sample attached image. What causes this, and how can we resolve? we have double checked the data and confirmed…
-
BI Publisher AP Check Print - Check Print on First Page Only
Summary BI Publisher AP Check Print - Check Print on First Page Only Content I am creating an RTF template for our AP checks. Our check prints at the bottom of the first page only and if there is remittance overflow it will print continue to print on the next page/s. I need help with getting the check to print only on the…
-
Row Data into Column Data
Summary Row Data into Column Data Content Hello, I have a requirement where I have to convert the row data into column data in the RTF Template. I have put the sample XML and the PDF Output and the desired result I am looking for. <?xml version="1.0" encoding="UTF-8"?> <!--Generated by Oracle BI Publisher 11.1.1.9.0…
-
Problems Installing Oracle DVML - gets Error Message
Summary Problems Installing Oracle DVML - gets Error Message Content I am trying to Install Oracle DVMl through Start Options from the Windows and it shows the below screen: Also, I tried to install through the link provided to download in Chrome but the installation do not start automatically and it just downloads the…
-
BI Server Crash-obiee12c
Hello Experts, I have migrated OBIEE from 11.1.1.7 to 12.2.1.2.0 few month back but facing a weird issue where every time i try to drill down any column, BI Servers crashes. I have also raised an SR to oracle but all they have asked is stack traces of core dump repeatedly with no action plan till now. Can anyone guide me…
-
How to join two facts.
Hi Team, Recently, I have attended couple of interviews. In Each Interview, they are asking How to Join Two Facts? I said, No.we cannot join. But they are asking if requirement comes like this, how can you do it? Can anybody please answer this question with steps? Regards, C.
-
Bad Request The request could not be understood by the server due to malformed syntax.
We are getting the below error when user ran the OBIEE analytics url in theur browser: Bad Request The request could not be understood by the server due to malformed syntax. At the same time we could see the below error in our ohs log file : [2018-01-15T12:52:34.1305-08:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [client_id:…
-
Aggregation Rule change behaviour in obiee 11g
Hi friends, Im in obiee 11.1.1.7.150120. I have a measure column called budget in the report like below You can see the total of that report like 2824483.60 which is correct, but if you sum up all the values manually you will be getting only 814500.29 which is wrong. Hence wondering how come im getting my grand total…
-
Control Break and conditional color formatting in the report.
Summary Control Break and conditional color formatting in the report. Content Hello, I am trying to create reports in BI Publisher. The report has the Control breaking and color coding in it. I am trying to get color in the particular cell based on the condition like the screenshot below. Please suggest me a solution to…
-
Is it possible to add a parameter which allow user to change and effect on the report?
Summary Is it possible to add a parameter which allow user to change and effect on the report? Content Hi experts, I am working on a report that will need some interactive with user. There is a parameter which will use in calculation and allow user to change the value of parameter(datatype is double). Does anyone know how…
-
OBIEE WebServices and named filters
Hello, I am trying to use OBIEE webservices for OBIEE regression testing. And I'm facing a problems with saved filters. I am able to get report's SQL by calling ReportEditingService.generateReportSQL but I am not able to set up filters of the report (tag <filterExpressions>) as they are stored filters (i.e. named filters),…
-
How to add "Saved Customization" to Favourites?
Hi All, I have applied saved customizations on my dashboard. I want to see it in the favourites bar. However, in the Catalog > Saved Customization > Add to Favourites (This option is not present). I.e For my customization, there is no option such as "Add to Favourites". So can anyone please tell me, how to achieve that?
-
obiee 12.2.1.0.0 dashboard page sub pages option
Hello, Couldnt find the option to create subpage for a dashboard page in obiee12c . We have a summary and detail report and client need it in two excel pages after export. So we need to create sub pages for better export. Any pointers will be highly appreciated. THanks Asim
-
Delta on Bar Chart
Hi everyone, So, I want to create this % variance between bar as the screen: Is it possible? If not, any suggestions? Thanks in advance.
-
Maps not working properly
Summary Maps not working properly Content Hi Team, I was trying to generate a map using the Oracle DV tool. But my maps are not loading properly. It is showing as No Image Available. Please help me witht his. Thanks
-
Query Builder question
Summary Query Builder question Content Hello. I'm new to BI Publisher and need some help. I'm working with the query builder. I add the tables from the left-hand side and then make the appropriate joins and select(tick) the columns to be included in the model. Then I want to see the selected columns on the Conditions tab.…
-
How to skip rows while creating a new data set (or later).
Summary How to skip rows while creating a new data set (or later). Content Hi, I am creating a new data set based on an Excel file. The file has a couple of rows at the beginning which I do not want to import. Is there any way we can ignore those rows while creating a new data set or delete those later? For example, I do…
-
Spacing issues in RTF template pdf out put.
Summary Spacing issues in RTF template pdf out put. Content Hi , I have below requirements in RTF template output.Please suggest how to achieve this. I had attached the sample report output for reference. 1.Adjust line spacing to remove empty white space in table. 2.Adjust side margins. 3. Adjust line spacing. 4.Adjust…
-
How to get lead and lag of a column in Dataflow
Summary How to get lead and lag of a column in Dataflow Content Hi I have a data as below, where NK is natural key, I want to acheive something like lag(job_code,1) over(partition by NK order by START_DT) prev_job_id lead(job_code,1) over(partition by NK order by START_DT) prev_job_id NK START_DT END_DT JOB_CODE 100…
-
Is DVD for a single user (Install user) ?
Summary Is DVD for a single user (Install user) ? Content Can only the user who installs the DVD can access it, not other users? my machine as two users, I install DVD, I can access, other user logs in, he cant access, as seems like C:\Users\<user>\AppData\Local\Temp\DVDesktop is created only for me, so when other user…
-
Is it possible to set up BI Publisher for high availability?
Summary Is it possible to set up BI Publisher for high availability? Content Hi all, I have just finished creating a two node OBIEE 12c cluster and was wondering if it was possible to be able to set BIP in a similar way so that if 1 node goes down, scheduled jobs continue to run on the 2nd node. Has anyone performed a…
-
Different Physical SQL's Generated on Two Systems
Hello All, We have a test and prod environments (12.2.1.3) which are almost identical systems except connection pool data source names. So we have the same report on two systems and almost the same NQSConfig.INI (prod has usage tracking). But these systems generate different SQL's. Things I checked: * RPD Database Types *…
