-
column fx based other column filter
Hi Every One, Below is the scenario which i need to implement in Obiee. Query : select c1,c2,(select c3 from t3 where t1.c1='1' and t3.c5='s' and t1.c2=t3.c2) as C3, from t1; I need to implement in obiee. Please help us. Thanks, S
-
DVD Essbase : ASO and measure dimension
Summary Can we change the default Measure dimension Content Hi, I am connecting Data Visualization Desktop to an Essbase ASO cube and it looks like that the Account dimension is not recognized with the "Measure" tag. Is there a way to change the default behavior? Is there a workaround? Thank you Version 12.2.5
-
Data Lineage in OBIEE 12.2.1.4.0
Hello Experts, We have OBIEE 12.2.1.4.0 installed on RHEL 7.3. We are trying to achieve Data Lineage to track which DB column is used where (report/dashboard) and to also see the impact of DB column change. Is there any utility that can be used to achieve this ? Please advise. Thank You. Rakesh
-
How to mimic an existing RPD file?
Dear Experts, We have two companies, one of them has an existing rpd file. We need to create the same like rpd, with some modification of course to be addressed later, in the second company. The question is there a way to export/get/retrieve all rpd layers including the logical tables, logical sources, diagrams and…
-
UDA support with DVD / DV Essbase
Summary Are UDAs supported in DVD / DV Content Dear team, Are Essbase UDAs (User Defined Attribute) supported in DVD / DV? UDA provide a flexible way to capture information as required, considering the fact that selection by level (LEV) is not available in DVD / DV 12.2.5 (ref to this thread), if wanted to workaround the…
-
BI Publisher : Custom metric label in gauge
Summary Custom metric label in gauge Content Hi, I have a scenario in which the metric label in Gauge should be customized. For example, I should be able to format the metric label text by appending '%' or any other custom characters. I could find that ViewFormat can be added to MetricLabel, but when…
-
RTL and Arabic language
Content Dear all, how to implement multi language in one project and RTL direction in DV ? Best Regards, Abdelrahman
-
JDBC Driver Not Installed
Content Dear All, i have problem to connect with JDBC and i am follow all steps in this documentation ,but this error appeared in below picture . Database Version : Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production . Oracle JDBC : ojdbc8 . Oracle Data Visualization Desktop 12.2.5.0.0-20180829155113…
-
OBIEE missing action link option
I am using obiee 11.1.1.9 on Windows OS. Till yesterday I was able to add a new action link "Navigate to BI Content" using column property in analysis criteria tab. But "suddenly" obiee is not offering "Navigate to BI Content" action link option anymore. To be more precise obiee is also not displaying "Navigate to a Web…
-
EXECUTE DIRECT DATABASE REQUESTS
Hi Folks, Is 'EXECUTE DIRECT DATABASE REQUESTS' has been deprecated for BI ADMINISTRATOR ROLE? If yes, then what are the alternatives for accessing the DB directly? Thanks
-
Cache Variable in obiee 12c
Hello, We are using OBIEE 12c and I created an analytic report. It has dashboard prompts. I did not enter or set any variable in the prefix section in the advanced tab. However, i found that it is set to SET VARIABLE DISABLE_CACHE_HIT=1; The report is being copied to different folders and also to higher environments. It is…
-
How can we restrict a user to write only numbers in the text fields in obiee 12c reports?
How can we restrict a user to write only numbers in the text fields in obiee 12c reports?
-
OAC & Google Big Query
Summary How to connect OAC to Google Big Query Content Hi, is there anyway to connect OAC to Google Cloud Platform (Big Query) ? Thanks
-
How to verify if fusion apps are installed on weblogic 10.3.6.0 ?
What is the best way to find out If they are any fusion apps installed on WebLogic 10.3.6.0. We are planning to apply latest patch to WebLogic .
-
Can we perform custom calculations on top of the Pivot view in OBIEE?
Requirement is to calculate Residual trend for customer’s i.e. % of customer remaining in each month: Row LabelsJul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17(blank)Grand TotalJul-161311985571084112671037031837359Aug-16 111183495986130354134357054Sep-16 100147390971103235316171 Row represents: Acquisition month of customer…
-
Get the ip public for Oracle Autonomous Analitycs Service
Summary I need the ip public of my Oracle Autonomous Analitycs Cloud service to allow access to my on-premise database Content I need to consume the data from my on-premise database. So I need to know the public ip of my autonomous service to open access to my local database from the internet. Thank you very much for your…
-
Level based measure query formation issue
Created a level based measure which is present in two logical hierarchies when this level based measure is used in report along with some columns which only belongs to one logical hierarchy but still report query is showing that the level based measure is over partitioned by key columns from both logical hierarchies…
-
OAC Visual Analyzer and PBCS
Summary OAC, PBCS, DVCS, PBCS Content Dear all The question might have been asked already but I could not find any recent answers. I'd like to use PBCS (BSO cube) as Data Source in OAC Visual Analyzer (and Data Visualization Desktop - DVD). I can see that both OAC VA and DVD support Essbase as direct Data Source but I…
-
Configuring Synonyms for DV - ASK indexes
Summary This describes an un-documented Beta OAC 18.3.3 Feature for Configuring Synonyms in DV ASK Interface Content Hello, if you are using Ask on your DV browser or via Day by Day, you probably wonder how to let user ask question with different object names than your datasource column names. Here is an brief article &…
-
DV Content Packs
Summary download location of DV Content Packs Content Where are DV Content Packs available for download - is the master location still on demo central? Cheers, John
-
Logical sql of a analysis of presentation server in OBIEE 12.2.1.4
When an analysis is created in OBIEE, then it goes to presentation server, generates a logical sql , generates a hash key to check whether the result is in presentation server cache or not. If not, then goes to bi server and checks whether the result is in bi server cache or not. I have got the logical sql of bi server…
-
Issue when upgrading artifacts from OBIEE 11g to 12c (cannot find services.xml)
I'm trying to migrate artifacts (including OBIA) from 11.1.1.9.0 to 12.1.1.4 when I run the migration tool, after exporting the jar file, I get the following error. SEVERE: Error on reading or wrting file services.xml: java.io.FileNotFoundException:…
-
OBIEE11g Agent delivery row level security problem
Hi everyone, I am using OBIEE 11.1.1.9.0 on windows. I have to configure Agents to send data to email to a group of users in monthly schedule. I have 60 users in BI Publisher which are created using realm (defaultAuthenticator). All this users are following a hierarchy (Region-Branch level of hierarchy) and row security…
-
function absolute in calculated item
Im trying to calculated the percentage difference between two columns using a calculated item ($2-$1)/$2 but it fails when both values are less than 0. Is there a way to apply absolute function? Documentation says yes but havent managed to make it work
-
Chart count orders Create date vs Closed date in the same chart - ODV Oracle Data Visualization
Content I have been able to create the information only in 2 different chart one to Counting Creation date and other to Close dateI need to create one chart with the information of how many orders have been created vs how many was closed in one month. and would be perfect to have a third line with the gap on every month…
-
DV Total Count always calculated in the highest level
Summary DV Total Count always calculated in the highest level Content Hello, I am using visual analyzer Version 12.2.1.1.0. Module Description: FactA - ColA, ColC FactB - ColB, ColA DimA - ColC, ColC_Desc FactA joins FactB on FactA.ColA = FactB.ColA FactA joins DimA on FactA.ColC = DimA.ColC MeasureFactB = count(distinct…
-
Column not displaying any data
Hi All, The development team was trying to create a dashboard, based on soemthing that shipped with OBIA. For one of the columns, we are not getting any data. I've starting to dig into the RPD and see what I can find out about this. So far, I can see some details from presentation layer on through the physical table. It…
-
DVD and Essbase
Summary Build analysis based on levels (LEV) and not generations (GEN) Content Dears, In my case selecting member sets by generations (GEN) is not appropriate as I am dealing with ragged or unbalanced hierarchies. Would it be any way to switch to levels (LEV) instead of generations? I am using latest version of DVD…
-
Moving calculated item
Hi I am using OBIEE 12c (12.2.1.2.0) I would like to know is there a way to move calculated item, for example i vreate calculated item that is sum of two columns, and OBIEE puts that calculated item on the end. Can i somehow drag it in between columns?? BR, Matija
-
Custom OTBI Role
Summary Custom role required to allow users to access OTBI reports and their data only Content Hi Community, Is it possible to create a custom role that will only allow users to login, navigate to OTBI and open a Analysis and have no other access in the UI? We are trying to build this for reports in the Procurement Module.…
