-
Connecting OBIEE Admintool to Hive : issues with ODBC. Any option ?
We're facing a blocking issue when trying to connect Admintool to a Hive instance by using any ODBC driver. For a POC we're trying to setup a Hive subject area to be analyzed in OBIEE. Everything seems to work OK until we try to load the metadata. In this case, the schema is found but no table under it. We can add the…
-
Use Action link to navigate to another page and change prompts accordingly
Hi everyone, I have created a pie chart with Lender and Debt%. Lets call this dashboard page 'Page 1'. Also 'Page 1' has dashboard prompts - Currency and Time Stamp set to prompted with default values I have created an action link on the Lender column to Navigate to 'Page 2' Page 2 has 'Time Stamp', 'Lender' and 'Currency…
-
OBIEE Agent running report once for each recipient
Hi All, We have configured the agent to send out a dashboard page to 10 people. Am using Run as specified user - weblogic, still it seems to be running reports once for each user. Is there a way to force agent to run once and broadcast results to all recipients ? Thanks for any pointers
-
Is it possible to use column selector in a union report ?
Hi, We have a requirement of having a column selector in a union report. Is it possible technically ? Thanks in advance for any inputs.
-
OBIEE 11.1.1.9.0 - Sample Application version 506 URL
Hi, Is there a running online version of the OBIEE 11.1.1.9.0 - Sample Application version 506 I want to demo some features to the business.
-
Help in finding difference of two dates
Hi, Could you please help in finding the difference between two Gate dates as new column in OBIEE.They have been separated as shown below. Thanks in advance. { Project1Gate NameGate 1 Open Date Gate2 OpenDateProject1Gate115-Feb-16Gate220-Feb-16Project2Gate11-Mar-16Gate210-Mar-16 } Regards, Lak
-
Reduce DAC 10.1.3.4.1 ETL Execution Time
Team, For Data loading through DAC ETL takes more than 2.30 hours. Earlier it takes only 50-70 mins. Environment - DAC 10.1.3.4.1 & Informatica 9.0.1 HF2. Wanted to reduce the execution time. As new to DAC & Informatica, kindly suggest from where to start and what are all the possibilities to reduce the execution. Thanks a…
-
Month difference in RPD
Hi all, I am using formula below to work out month difference in OBIEE TimeStampDiff(SQL_TSI_MONTH, A, B) which condition does formula does? A - B or A - B Thanks
-
Obiee connection to SSAS
Hi All, One of our data sources is SSAS , I am going to connect BI admin to SSAS. I could find some instructions on rittman site but apparently there are some problems with SSAS hierarchy detection. Is there any one who is experienced with connection Admin tool to SSAS? I created a XMLA connection type in admin tool but my…
-
Essbase Calculated Member retreival in OBIEE Reports takes time
Hi , My OBIEE version is 11.1.1.7.0 ans have a ASO cube in Essbase 11.1.2 as my source. There is one ASO calculated member whose retreival in reports takes a lot of time. Any optimization measures suggested to reduce the wait time in OBIEE. PS-We have OBIEE Hyperion integration in place already. Any heads up on improving…
-
Presentation Catalog automate deployment
Hello to all OBIEE experts. I`m currently looking at a way to automate presentation catalog from one environment to the other (Dev,Test,Prod). We are currently running on Windows using Obiee 11.1.1.9. I did a bit of research but my only findings were for a Linux OS utilizing runbat.sh command. I understand that there is…
-
OBIEE 12c Admin Tool Crashing when importing Essbase Cube
Hello, I am working in OBIEE 12c and I am trying to import an Essbase Cube. I am able to connect but when i try the import the cube, the Admin tool crashes. Does anyone have any idea why this might be happening? I have checked the Admin Tool log files but still haven't had success on finding the issue. thanks
-
Defining the range in OBIEE graph 0-10, 10-20, based on data
Hi, I have requirement in OBIEE 11g reporting where as attached in the image we need to display range of data even there is datapoint. For eg. Range in X-Axis 0-10, 10-20, 20-30, 30,40, 50-60 with blank data and continue with 60-70...90-100 with data The range should be defined based on the maximum value in Rate field. eg.…
-
OBIEE is not supporting Timezone format
Hi Team, Even if Date/Timestamp columns with Timezone format is created in Database, OBIEE is not supporting it. We have created a table with timestamp with Timezone and tried querying using direct database request, even then OBIEE was throwing error "Oracle db error - unsupported data type." Thanking you.
-
Error while installing OBIEE 11.1.1.10.1 in Linux
[2016-02-12T00:25:26.000-08:00][OBIPS][ERROR:16][][saw.catalog.impl.checkForClockSkew][ecid:005AstcV6wg2vH05yyjH7iW0006rm000000,0:1][tid:975410944] Files are being created in the future. The NFS mounted File System server system time and the OBIPS server system time are off by more than 4 seconds. This can lead to…
-
Unable to login to BI 12.2 analytics
Hi All, I installed and configured BI 12.2 everything finished smothly and I can login to the em and the console but I am unable to connect to the analytics.
-
"Sort has no Space in the Work Directory"
Hi all, I am running a query when I came across this error (after a good 30 minutes) I understand from online sources that this boils down to a lack of memory issue. However, I have ample memory (and my system did not show any issues when I was running this query). In addition, the file mentioned here is a temp. file which…
-
Can I install only BI Publisher 11g standalone (i.e. without OBIEE)
Hi all , Can anyone help me to figure out the difference between OBIEE and Oracle BI publisher .. I want to install only Oracle BI publisher , so I still need to install OBIEE? Thanks A
-
Why do all my executeXMLQuery calls fail in SoapUI?
Running OBIEE 11.1.1.7.140527 on linux. Running SoapUI 5.1.3 on my Windows 7 laptop. Step 1: Call the logon service to authenticate and establish a session: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v6="urn://oracle.bi.webservices/v6"> <soapenv:Header/> <soapenv:Body> <v6:logon>…
-
Identity store does not contain group name
I'm trying to send out an agent to a user group. The agent appears to execute correctly, but none of the users recieve their email. In the enterprise manager, I get an error saying the identity store does not contain the group name. Any idea how to resolve this error?
-
Runtime RPD transformation error importing 11g BAR file to OBI 12c
HI, I've Installed OBI 12 on Linux and Installation with SampleAppLite ran successfully. However, every time I tried to import the BAR file from an existing OBI 11g server I get the same error in the config.sh tool: 2016-02-09T15:11:26.420+02:00] [bi] [ERROR] [] [oracle.bi.migration.RPDTransformPlugin] [tid: 112] [ecid:…
-
Need to access OBIEE 11g 11.1.1.7.0 dashboards on Mobile and Tablets
Hi All, We have a requirement to enable users to view Dashboards built in 11.1.1.7.0 on Mobile and Tablets. Can you please let us know the appropriate Infra setup to get this. Do we need to build the dashboards to be built again ? Thanks
-
Help with Formula Syntax please
Hello I have the following code. It works OK but i need to setup the date manually not to get CURRENT DATE. The date I want to setup is Oct-11-2015 Can you please help me with the Syntax. What this does Is to make Buckets: 0-30 days 31-60 61-90 91-120 121+ days so that calculation is made CURRENT DAY (minus) ABAY Start…
-
OBIEE 11g Gauge Blank
Hi All, Version-Oracle Business Intelligence Product Version 11.1.1.7.150120 (Build 150111.1659 64-bit) Our OBIEE Report Gauge is blank suddenly with same threshold/formulas as in dev environment. I checked all the formulas.Everything is exactly same in dev/uat.What might be the reasons for UAT gauge blank? UAT: Thanks R
-
How to install OBIEE 12c with Horizontal Cluster
Hi, Can any one help me to giving installation steps for OBIEE 12c with Horizontal Cluster. Below is my environment, Node 1: Solaris 10 u11 x86 Node 2: Solaris 10 u11 x86 Node 1 is master node. I never install OBIEE 12c.
-
Is there a way to display all column level security?
We are about to inherit an RPD from another department. There are many subject areas, hundreds of roles, and column level security has been set at all levels (subject area, presentation folder, presentation column, etc). We will literally need to go through every element in the presentation layer to find out how everything…
-
OBIEE 12c: Missing image qual_vaproject_24.png for blafp style
Hi colleagues, I have found issue with blafp style at obiee 12c. Customization has not the image (qual_vaproject_24.png) as a consequence home page is not displayed correctly.
-
Find connections between reports
Hello experts I have many reports which link to other reports (by action link). When I change one report, I want make sure that the reports that called by the changed report or reports that call to my report, still valid There is a way to identify such connections (it possible many to many connections ) ? I thought to…
-
OBIEE 12c - Repository doesn't "stay put" on server restart
Running OBIEE 12c under Windows Server 2008. I have been using the data-model-cmd.cmd uploadrpd command to activate a repository. As long as I do not restart the machine, all is well. But when I restart the machine, the repository is no longer active. I have to run data-model-cmd.cmd uploadrpd again. Is this the expected…
-
Start/End of Last Week regardless of run date during this week
Hi everyone, I'm new to OBI and wanted to pick your brain on something that driving me insane. I want to create a report that will run some aggregation for a date range that spans last week (from Sunday through Saturday) regardless of when its run in the week. So, example. If today is 2016/02/09, then when i run this…
