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
2
votes
1 answer

OBIEE 11g Hierarchical columns. How to accomplish what we would normally do with a union report

So we have a hierarchy relationship for phases of a process: Overall Phase |----Phase 1 |----Intermediate Phase | |----Phase 2 | |----Phase 3 |----Phase 4 Then we have many objects that go through these phases. These…
JCL
  • 189
  • 1
  • 2
  • 11
2
votes
1 answer

Why a Query Is Not Added to the Cache in OBIEE12c

Some cases query results do not insert in the cache where the logical sql query was suppose to insert into the cache. As a result, frequently cache missed occurs. Would anyone please explain the reasons for not insert a query result into the…
user18177642
2
votes
1 answer

How to show only highest education in OBIEE

Good evening everyone, I am using OBIEE and I am trying to extract a file containing some candidates' information to keep in our records, as my organization will need to delete most data soon. I have data related to recruiting that people put in…
Ad.dan29
  • 25
  • 5
2
votes
1 answer

OBIEE Charts do not show because of adobe flash player

OBIEE uses flash player to render charts. After discontinuing support of adobe flash player, obiee charts do not display. Is there any way to render obiee charts without adobe flash player.
user16893674
2
votes
1 answer

how to take backup of RPD and Catalog of OBIEE12c?

I would like to take backup of RPD (i.e., OBIEE12c metadata) and Catalog (i.e., save BI analytical reports, dashboard saved in both my folders and shared folders) in order to restore in the test server for the research purpose. OBIEE12c Version:…
user16893383
2
votes
0 answers

How to get minimum records from the Oracle fusion run report API

Requirement: I am using the runReport API from the Oracle fusion report service to get the data by passing the parameter values as arguments. It generally takes more time for larger reports. So is there any way to get the total row count or else…
Venkat
  • 2,549
  • 2
  • 28
  • 61
2
votes
2 answers

Finding Difference between two rows grouped by a date or between two pivoted columns

I have a set of values for two different dates in my OBIEE report: ------------------------------------------------------------------ Option Date Value ------|---------|------- OPT1 Date 1 5 OPT1 Date 2 2 OPT2 Date 1 …
Junaid Ahmad
  • 41
  • 1
  • 9
2
votes
5 answers

New to Oracle BI

I used some reporting platforms ( SAP Business Objects and some other third party applications). I have pl-sql experience but I am new to Oracle BI. At this point, I have some questions which confuses my mind. First one is there are lots of…
computrec
  • 21
  • 2
2
votes
3 answers

Get time and number of OBIEE 12c users login

My requirement is just to monitor and know how many a user log in per month.I need to count number of logins for a user with the time they login Can anyone please help me in how to do this? Is there any log file such as obis1-query log file for…
Atefeh
  • 181
  • 1
  • 17
2
votes
1 answer

Setting a data format common to all analysis in obiee 12c

Is there any common configuration in OBIEE 12c , which allows to define decimal places applicable to all analysis? For example,presently, if you want to set the decimal places for currency column, you need to take the data format of that column and…
Gautham Narayanan
  • 66
  • 7
2
votes
1 answer

OBIEE Passing Parameter to Analysis With URL

I have this Analysis that I wish to invoke from URL (which I can). This analysis in particular is mounted on a dashboard and 6 of the 17 columns can be filtered from a prompt mounted on the same dashboard. I only need the analysis and still be able…
parmigiano
  • 95
  • 1
  • 14
2
votes
0 answers

Oracle: OBIEE - standard deviation

I need to calculate the standard deviation for the numeric variable "amount" by the factors: "Area", "Category", "Subcategory" as a function of "Day". For more detalis see the figure below: I already cheched on Google and ask in StackOverfolw how…
user1010441
  • 59
  • 1
  • 7
2
votes
1 answer

Passing parameters to stored procedure in OBIEE 12c rpd from OBIEE 12c dashboard

I am trying to create an OBIEE report using stored procedures. I have created a function in SQL Developer which takes a parameter and returns refCursor as output. I, then, set the following query as default initialization string in physical layer of…
Aman Agarwal
  • 31
  • 6
2
votes
1 answer

Dividing 2 column expression does not give a valid result

I am doing the following calculation , SUM(A by Category)/SUM(A + B + C by Category) Both the calculation individually gives values but when division is done the result is always 0. Could anyone help what's wrong with the above expression?
sarabanv
  • 21
  • 9
2
votes
0 answers

ORA-00904 when trying to query data via OBIEE

I have a view with the below SQL working and pulling data in Oracle SQL developer, but when I import this view in to the OBIEE repository and try to view data I get the error above. Originally the alias was "Segment" but I thought it might have been…
Brett Moore
  • 23
  • 4
1
2
3
…
51 52