-
Chart Alerts
Summary Does DV have Chart Alerts Content So i come from the Tableau world and am new but excited to use DV. I searched around but i don't see any info on this subject. Does Data Viz allow me to create a chart and if a certain threshold is passed, then automatically email that alert and image of the report to a user? thank…
-
Build Job Import Export on DEVcs
Summary Build Job Import Export on DEVcs Content Hi All, We have created build jobs in developer cloud service classic version.We want to migrate same build jobs to another version of Developer cloud service.Is there any way to export the existing jobs and import the same to another Developer cloud service version?…
-
Failed or Incomplete Oracle OBIEE Client Install
I am very new to OBIEE, so my apologies for these newbie questions which likely have very obvious answers (just not to me), but I did spend hours googling madly for answers, yet still I struggle. I am attempting to follow the tutorial "Creating Analyses and Dashboards" here:…
-
OBIEE 12c prevent end users from using Data Visualization
Hi All, We have some licensing restrictions, and we can't use Data Visualization module. Question: How can we prevent end users from using Data Visualization in OBIEE 12c (12.2.1.4.0) and ensure that we will not to violate the license agreements? Cheers!! eMarcel
-
How to connect Kylin
Hi Experts, In BIEE 11G, I want to know how to connect the Kylin Tools for multidimension data . I tried to download the special Kylin ODBC "Apache Kylin | Download " and installed it. But I do not view data in Admin Tool successfully.When I will do it, the tool will be closed automatically. By the way, I also do not join…
-
OBIEE Joins
Table "A" and Table "B" are joined at the physical layer by an ID field. Table "A" is the primary table and has a larger population of ID values. Table "B" is a secondary table, and contains a subset of the ID values. In the Business Layer, these tables are connected via a Logical Join as follows: - The diagram looks like…
-
Display custom messages in Writeback Reports OBIEE 11g
Is there any way i can display a custom message when user enter the wrong data(conditions).I am using OBIEE 11.1.1.7.1. Anyone please help me out here. Thanks, Manu
-
Letter generation in OBIEE Analytics
Hello to whom it may concern! We have two questions: 1. We are wondering if there is any way to use specifically OBIEE 12.3 analytics to perform a letter generation task for a bunch of customers, or are there any other tool that can be used to accomplish this task? 2. Could be a letter generated, delivered to an external…
-
PaaS – Empowering business with more sophisticated, faster analytics with Oracle Cloud Platform, 22
Content Submit your questions for the PaaS – Empowering business with more sophisticated, faster analytics with Oracle Cloud Platform session to have them answered during the live event. Post your questions by posting a new comment to this topic. Please submit your questions by Tuesday, 21 August 2018.
-
Dynamic output Filename
Summary Dynamic output Filename Content Hi, I am using BIP 12c and need to dynamically set the output filenames for reports delivered over Email as excel and pdf. I need to name the files as myfile_ddmmyyyy and put mail subject as report_for_ddmmyyyy As per Oracle docs…
-
OBIEE 12c Logical SQL with Factor query
Does anyone knows how to write logical SQL with factor query in OBIEE 12c? I couldn't find any documentation from the website. If you have experiences on that, would you please share with me? Thank you very much?
-
Runtimesubvar Inside Smartview Possible?
Content According to John's blog, in Essbase 12c, it is possible to have a RTSV inside a calculation script that will pick up a SmartView POV as long as the calc is run from SmartView. In the blog, he says that this feature has not yet been rolled out to 11.1.2.4, but it may be in a later patch. Was this feature ever…
-
OBIEE 12C Session Variables are not working as expected
I would like to append the following code DISABLE_CACHE_HIT=SESSION VARIABLE. The other one is the following variables are appending automatically. SET VARIABLE QUERY_SRC_CD='Report';SELECT SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/shared/Fixed Assets/_portal/Fixed…
-
repository variables issue
Hello Experts, Recently we have moved to OBI12.2.1.3.0 I have a fact table and in content tab condition has been mentioned:- "Sales Performance".""."Sales"."F_SALES_LAST_DATE"."LAST_S_DAY" = VALUEOF(LAST_SALES_DAY). Default value for LAST_SALES_DAY = 2018.01.01 Actually it should show today date = 2018.08.20 but its still…
-
Getting error while creating datasource in OBI console
Hello Experts, We have upgraded our OBI environment to Oracle Business Intelligence 12.2.1.3.0. We are getting below error while creating the datasource in OBI Console:- Could not establish a connection because of java.lang.IllegalArgumentException: ONS configuration…
-
"Failed - IO Error" when Customizing Disbursement Payment File Formats
Summary Can't Customize Disbursement Payment File Formats Content I am trying to set up a new Payment Format called "MT9" which is specifically used by New Zealand Banks. According to Oracle Documentation (http://docs.oracle.com/cd/E51367_01/financialsop_gs/OCCAR/F1560030AN107C4.htm#F1192364AN1232D), it is recommended to…
-
Column selector - sorting for details
Hi, Using OBIEE 12c. Report with column selector. One of the possible options is Tenure group (length of service grouped) containing CASE statement: CASEWHEN timestampdiff(sql_tsi_month,"Person"."Vesting Date",date '@{PV_ENDDATE}{2018-04-30}') <=0 THEN 'Future date'WHEN timestampdiff(sql_tsi_month,"Person"."Vesting…
-
No results message
Hi, i am using OBIEE 12.2.1.2.0 Sometimes when my analsys results in no data it gives me the sentence, The combination of parameters... resulted in no data, and on some other analysis it gives me the exact parameters , why is sometimes the user friendly setence and sometimes parameters...? THX, matija
-
OBIEE prompts
Hi, i am using OBIEE 12.2.1.2.0 Something like this happens, Dashboard has 3 sections , 1 normal and 2 sections that are conditionaly shown depending of the value of the prompt placed in first section. When i change the value of the prompt it shows me other prompts that i put in a conditional sections, but in some cases…
-
does updating var requires restart of all bi services or only few
This is obiee 12.2.1.2 I am udating my connection pool and rpd variables like below.. ./datamodel.sh updaterpdvariables -C /home/rpdvars.json -U biuser -SI ssi ./datamodel.sh updaterpdvariables -C /home/connectionPools.json -U biuser -SI ssi Do I need to rest all the the bi services or few or none. Didn't find any doc that…
-
OBIEE 11g High availability setup
Hi, Currently we are on OBIEE 11g on Windows Server. Would like to set up OBIEE 11g High availability system with 2 nodes for 24/7 availability. Could you please point me to any documentation/white paper/guide with detailed step by step instructions for this setup. Thanks in advance, Raj
-
Substitution Variables in Fusion ERP Essbase Cubes
Summary Substitution Variables in Fusion ERP Essbase Cubes? Content The ERP Essbase cubes are automatically maintained in the background. Is there any way to create substitution variables in those cubes?
-
Why DATACOPY command doesn't work inside IF statement in ESSBASE
Summary Why DATACOPY command doesn't work inside IF statement in ESSBASE Content Why DATACOPY command doesn't work inside IF statement in ESSBASE? Thanks Venkataraju Saripella
-
OBIEE 11g Server unresponsive
Hello, We are on Linux based: Oracle Business Intelligence 11.1.1.7.150120 Our production server became unresponsive. No one could hit the /analytics url, our sysadmin couldn't even ssh/putty into it. Our monitoring tool Opmanager showed 100% CPU. Eventually we were able to ssh into the server using putty and saw that the…
-
OBIEE (12.2.1.4.0)
Hi all, Has anyone installed this version yet? Initial thoughts? We have just installed 4 new 12.3 servers (pre prod only at this stage) and the boss is already talking about moving onto .4 before we live because the integration between DV and OBIEE has been fixed (apparently). Obvoiusly I have concerns rolling out a…
-
Aggregation rules, group by
Hello everyone, This is my first post, so I hope it finds you all well and thanks in advance for any support or contribution. I am a very beginner and on my way to creating a more "advanced" report I am facing some difficulties to achieve my goal and therefore here I am. In my report I need to create a condition which…
-
List of Data Identifiers etext files
Summary List of data identifiers for etext files Content Hi, I have been creating several payment file templates and I always struggle with finding the correct "Data" commands or identifiers such as: "Payee/Name", "PaymentAmount/Value", "PayeeBankAccount/AccountNumber", etc... Is there a list or a way where we can know…
-
Missing some pixels into the header while generating a PDF
Summary The top pixel of my characters are missing when generating a PDF Content Hello everybody, I'm using BI Publisher 12c and an RTF template with MS Words 2013. I got an header problem that seems to appear only when I'm generating a PDF version of my RTF template. The logo I'm using in the template is made of 3 tables…
-
Accela & BI Publisher integration
Summary Accela and BI Publisher integration Content Hello All, Do any of you know if we can integrate BI Publisher reports in Accela( accela is a Government software that streamlines land, permitting, asset, licensing, right-of-way, legislative management, and resource and recreation management) We can integrate Oracle…
-
Page number of Page Count Peoplecode for BIP Report Merger
Summary How to get the Total page Count when merging 2 reports? Content Hi All, I have 2 BI Publisher reports that are getting merged in an App Engine into 1 report pdf. I can use the following to get the page number: /*** Page Number ***/ Local PSXP_ENGINE:PageNumber &oPageNumber = create PSXP_ENGINE:PageNumber();…
