Stack Overflow
Stack Overflow

Questions tagged [obiee]

Oracle Business Intelligence Enterprise Edition (OBIEE, formerly Siebel Analytics, formerly nQuire) is an integrated business intelligence suite from Oracle Corporation.

image Oracle Business Intelligence Enterprise Edition, also termed OBI EE, is Oracle Corporation's set of business intelligence tools.

766 questions
7
votes
2 answers

How can I integrate Oracle BI into an existing application?

I have an existing application written in Perl. Now I need to integrate this application with OBI. The plan is having a button the user can click on to open OBI in an iframe. OBI resides on a different server from the running application. Has anyone…
user32489
  • 141
  • 1
  • 3
7
votes
3 answers

Is anybody using OBIEE (formerly Siebel Analytics) ? What is your experience

We are in the process of selecting BI stack for our data warehouse. The top contenders are OBIEE = Oracle BI Enterprise Edition (formerly Siebel Analytics) and Microstrategy. Has anyone worked with OBIEE? Lessons learned? General impressions? Flaws,…
user33188
  • 71
  • 2
  • 2
5
votes
2 answers

kinit(v5): Client not found in Kerberos database while getting initial credentials

I'm working on configuring SSO in obiee 11.1.1.7.14, where in which I'm facing issue in the step while configuring krb5.conf and executing the kinit command. few notes regarding the Active Directory we have more than one domain controller and to…
user3714699
  • 61
  • 1
  • 1
  • 3
4
votes
1 answer

Automatic smart view hyperion refresh with VBA

maybe someone could help me to understand, what I'm doing wrong, as I'm stuck.. In general, I have a process, where I have an .vbs file, that triggers macro file, which makes connection to Hyperion and refreshes sheets. For some reason, when I'm…
Yuriy T.
  • 195
  • 2
  • 4
  • 12
4
votes
1 answer

OBIEE 11g Users are not visible in Identity Manager within Administration Tool which are created in Weblogic

OBIEE 11g Users are not visible in Identity Manager within Administration Tool which are created in Weblogic. Login The Oracle WebLogic Server Administration Console. In the Security Realms Create user and assign them Groups BIAuthors,…
Obiee Developer
  • 43
  • 1
  • 3
4
votes
1 answer

adding jasig CAS authentication for OBIEE (Oracle Business Inteligence)11g

I'm trying to add CAS as an authentication provider for OBIEE 11g. up until now I've added the cas-client-core-3.2.1.jar jar to $MW_HOME/wlserver_10.3/server/lib/consoleapp/webapp/WEB-INF/lib/ and…
Shay
  • 1,245
  • 7
  • 14
3
votes
1 answer

Fail to create ODBC Systems Datasource for OBIEE 12.2.1.4 Admin tool

On the client machine where Admin tool is installed, navigate to "Control Panel\All Control Panel Items\Administrative Tools". Click on Data Sources (ODBC) to open it. Navigate to the System DSN page, and click on "Add" button. Select the Oracle BI…
user16647218
3
votes
1 answer

obiee12c RCU creation fails with oracle database 19c

I have installed OBIEE12c(12.2.1.4). OBIEE12c certification matrix says RCU creation utility supports oracle database 19c. However, when I run RCU creation utility it fail prerequisite with the following message Processing command line…
user16647218
3
votes
1 answer

OBIEE 12.2.1.2 - Custom Data Format for numeric values

I am facing problems with the custom data format in the latest OBI release. The following format is used and I have problems in dealing with null values - in this case significant digits, which I still want to be displayed: +$#0,#.0,,M;-$#0,#.0,,M…
Max Power
  • 69
  • 1
  • 12
3
votes
2 answers

OBIEE adding an integer to date

I am looking to add a number of days (column 1- integer) to a date (column 2- date) to create another date in the future (column 3- date). What is the code required?
Phil
  • 51
  • 5
3
votes
4 answers

Tuning OBIEE generated SELECT queries

We have our data marts/warehouse on Oracle 11g implemented as a star schema. Business reports are designed using OBIEE. I come from a ETL background and have very little knowledge in OBIEE. Once the OBIEE RPD is designed, I see that OBIEE starts…
museshad
  • 498
  • 1
  • 8
  • 18
3
votes
2 answers

OBIEE: Casting String to date then date to string

FILTER("source"."recordCount" USING "source"."snapshot_date" = EVALUATE('TO_CHAR(%1, ''YYYYMMDD'')', TIMESTAMPADD(SQL_TSI_DAY, -7, EVALUATE('TO_DATE(%1, %2)', "source"."snapshot_date" , 'YYYYMMDD')))) So i have this piece of code here. I know…
user4606397
  • 31
  • 1
  • 1
  • 2
3
votes
3 answers

How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using a simple SQL query which fetches aggregated data from a data warehouse? I need the date in a simple dd-mon-yy format. I am not able to locate where…
MontyPython
  • 2,906
  • 11
  • 37
  • 58
3
votes
2 answers

Summing by Column

Suppose we have the following columns: X Y Z Category Date Amount A January 10 A February 20 A March 30 B January 34 B …
ifguy12
  • 31
  • 1
  • 1
  • 3
3
votes
2 answers

correct query design? cross joins driving ad-hoc reporting interface

I'm hoping some of the more experienced database/dwh developers or DBAs can weigh in on this one: My team is using OBIEE as a front-end tool to drive ad-hoc reporting being done by our business units. There is a lot of latency when generating sets…
sion_corn
  • 3,043
  • 8
  • 39
  • 65
1
2 3
…
51 52