-
Logical Column Mapping...!
All, I have a requirement i need to display same column from Two tables and its a snowflake schema. I want to display data from AL_FACT_ENG_EBOM and AL_FACT_ENG_EBOM_LEVEL_ZERO same column is available in both the tables.. How can i map same column from both table ?? is it possible to do it?? Hoiw
-
Calling a stored procedure in BI Publisher Datamodel
Summary Calling a stored procedure in BI Publisher Datamodel Content Hi All, I want to call a Oracle Stored Procedure with output parameters in Oracle BI Publisher DataModel. Any idea on how to use the 'Procedure call/Non Standard SQL' for achieving this?
-
How can i pick up correct value based on the date
I am working on a requirement that requires me to get a count of job applicants to specific job groups based on date they applied, if they applied to same job group within six months, then I pick up the first application, if its on different job groups within the six months then I count both applications. I have done my…
-
Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2
Hi Experts, I got a requirement to display the hierarchy columns in expanding by default in the Oracle Business Intelligence 12.2.1.4.0 version. Is there any configuration steps need to change, can you someone help me to achieve this requirement. Thanks in advance.
-
Dashboard Graphs issue in some browsers
Hi I have developed some dashboards in OBIEE 12c by using Google Chrome and added some 3D graphs, my client is using Internet Explorer, it has been observed some graphs are not showing and some are showing but not properly (I have checked same issue on my computer also) however graphs are working fine on Google chrome. I…
-
Displaying Actual Value & Percentage Together for a Pie Chart in OBIEE 12c
Hi Gurus, I want to display both Actual Value & the percentage values in a pie chart of OBIEE 12c. For e.g. Region Value A 100, B 100, C 100 Total 300 Now I want to make a pie chart of this report on OBIEE 12c displaying both Actual value & % value in the pie chart A - 100, 33,33% B - 100,33.33% C - 100,33.33%. Can someone…
-
How to add Apache Spark SQL in Admin Tools?
Hi Experts, Our BIEE version is 11.1.1.1.7.X,and want to use the navitive Apache Spark SQL, but we do not find it in Admin Tools . Is there any method to add it like BIEE 12C? If it is yes, how to do it ? Thanks very much.
-
Install EPM 11.1.2.3.500
Summary Need to get Installing package for Linux Redhat EL 6 (UL1+) Content Hi, I need some help please. I have to install to my client in production environement EPM 11.1.2.3.500 in the Redhat 6 (UL1+) version. First : Where could I download this version please? Second : Is there some rules to follow, especially It will…
-
OBIEE 12c : Horizontal Scaling - Command Clone_bi_machine.cmd Fails at Pack Jar File Stage with Erro
On Oracle Business Intelligence Enterprise Edition (OBIEE) V 12.2.1.3.0 While Performing Horizontal Scaling, the Clone command "Clone_bi_machine.cmd" is failing at pack Jar file stage with error : Argument(s) "domain c:\mwhome\bi\bin\..\..\user_projects\domains\bi" not supported. Error: Call to…
-
RPD -- BM and Mapping:- Data not displaying on Analysis
Hi All In Business Model and Mapping there are two fact logical tables and many dimensional, as you can see in below Figure, I have written below statement in field of F2 Lab Revenue which is also highlighted. I have a requirement to show LAB revenue separately, Total Cash Amount contains cash of every department, after…
-
OBIEE 12c certtification
Hi , can please someone tell me is there a certification exam for OBIEE 12 c, something like ''Oracle Business Intelligence Foundation Suite 11gEssentials'' Best regards, Matija
-
Sometimes not able to upload rpd
I'm using the sample app on a vm to learn obiee and I sometimes have trouble uploading the rpd I've been working on in BI administration tool. Usually it works but sometimes it refuses to work and I'm stuck and unable to continue until it mysteriously starts working again. BI is up and running and I'm able to log into…
-
Snowflake vs star schema in obiee 12c RPD
Dear All, Snowflake vs star schema in obiee 12c RPD Current scenario Snowflake with 5 tables Region category and country fetched through 3 tables snowflaked with the dimension customer. through ETL we can load the country region and category information to the customer table and make it a star schema. Can somebody help me…
-
To display data of Last 12 months in Analysis
Hi All I have a requirement to show data of last 12 months, I read following links but could not fullfil my requirement properly. OBIEE in IL: OBIEE - Few options to compare data to previous month, Year or something... https://www.clearpeaks.com/retrieving-revenue-average-of-last-n-months/…
-
BI Pub DataModel - Rows Dropdown in DATA Tab for xml is showing 200 as maximum in 12C but not ALL as
Summary BI Publisher xml output Content Hi Gurus, We're using BI Pub version 12.2.1.3.0. When trying to export the xml for creating rtf, the ROWS dropdown is showing 200 as maximum #of rows but not ALL as in 11g. Is this something that can be adjusted? Please let me know if there's a chance a changing this to ALL. Thank…
-
Highlight a Clicked Bar when sending master detail event
Hi, We have a simple bar chart with Master-Detail link enabled. In the Edge browser, clicking a bar to send an event sets the bar to white color, as shown below, which is the desired behavior. Edge Browser – In Chrome and other browsers - When you click, the bar is highlighted, but only on the edges with the borders as…
-
WebService with IDCS federated users
Summary WebService with IDCS federated users Content Has anyone using BI WebService (http://host:port/analytics-ws/saw.dll/wsdl/v7) in OAC env's? Wondering the logon method is working for you guys with IDCS federation. Thanks!
-
how to remove one specific row from data using a dashboard prompt?
for some reason I am struggling to create a way to filter one specific row in my data. My data has about 100 lines but one is skewing everything else. I would like the user to be able to filter this one out from a dashboard prompt. I create a session variable, radio button, custom values 'Yes' and 'No', with default…
-
How to set the default BIP default output formats
Summary How to set the default BIP default output formats Content We have created the reports through the BIP and for each and every report there are some default output formats ara predefined if my required output format is not there then I will edit the report and then I will go to the review list from there I will…
-
Custom Barcode label formatting in BIP 11g
Content Hi, Looking for you expert guidance on how we can create BI Publisher format template for custom barcode label of size 4" x 1.5". I'm able to generate the barcode successfully however it currently gets generated in full size sheet which I have issues printing in a Label printer. Thanks in advance! Regards Arun…
-
Account numbers with 3 spaces in database display in OBIEE with only one space
I have account numbers that are a mix of alpha numeric characters example W_ _ _123456. (The underscores are only to show the number of spaces). This is how the account numbers show in the database and also in SQL Developer when I run a query against the database. When I export to Excel or CSV from SQL Developer after…
-
Pass Same prompt values with different way
Hi All I have single prompt (Date), I want to pass date to my performance tile (already working fine) but I want to pass month without creating new prompt to Date wise revenue analysis. Is it possible?
-
OBIA 7964 road map
Hi Experts, What is the road map for OBIA 7964? Is any conversion tool we can expect infa to odi ? Thanks in Advance!!
-
OBIEE backend query not having NOT IN operator
Hi, While adding a column filter with "not equal to / is not in" operator, OBIEEE backend query is generated like below. t552147.account_seg12_code <> '15501' AND t552147.account_seg12_code <> '15500' AND t552147.account_seg12_code <> '15504' AND t552147.account_seg12_code <> '15600' AND t552147.account_seg12_code <>…
-
Dynamic Connection Pool in RPD
Hi All As you can see in below figure, I have to hardcode the data source name and credentials, I have three servers as following * Dev Server :- This server is for development * QA Server :- This server is for testing * Production:- Final destination of object, for end users As i have to deploy RPD on all the servers and…
-
Filter on Last Day of Previous Month (Criteria)
Can someone please advise me why I can't use this as a SQL Filter? "Gregorian Calendar"."Date" = TIMESTAMPADD(SQL_TSI_DAY , -(1), TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH("Gregorian Calendar"."Date") * -(1) + 1, "Gregorian Calendar"."Date")) When I put the expression in a formula it returns the correct date 12/31/2018 ....…
-
Obiee 12c multiple instances
Hi every one, I have two stand alone installations running on different machines, I did the installation using different paths, users and ports, and everything related to it runs on SAN disks. Here is the thing, they are stand alone because they were not suppose to have a dissaster recovery strategy, but now it turns out…
-
Needs expert opinion -- RPD
Hi All I am working in hospital where 4 major domains * Financial * Administration * Treatment * Diagnostic I have created on connection pool in RPD for financial and developed some objects suchas analysis, KPI, dashboards etc, now I have some requirements in other domains too, what is recommendation either I should add…
-
Use Narrative view to populate hidden prompt values
Hello! We are attempting to populate hidden prompt values via Narrative view as described in the Youtube video "Custom Interactions: Prompts" (https://www.youtube.com/watch?v=p7Ja1K_7wIY), however we have run into difficulties with JavaScript because we lack the SAutils.js file that is being used. Where can we find this…
-
Pass Prompt value as parameter to another prompt
I want to pass Year prompt Values to another prompt which is month prompt and then month to date. as you can see in Fig.1 and Fig.2, I Fig.2, at highlighted point, I have tried different methods to pass year prompt but fail, plesae help Fig.1, Year Prompt Fig. 2, Month Prompt
