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

How to add toggle button at column level in Oracle Business Intelligence 11.1.1.9.0 (OBIEE)

I'm new to Oracle Business Intelligence 11.1.1.9.0 (OBIEE). I want to add a toggle button (+) at the column of the report. By default, the report should display single value and Once if the user clicks the plus symbol it should expand to show other…
Suchitra
  • 1
-2
votes
2 answers

Restrict data of all months based on current day of month in Obiee

How can I restrict the data of all the months based on Current day of month. Supposed day of month is 18 so all previous months will give me data only till 18th and not more than that in Obiee?
Ujjayini Bose
  • 3
  • 1
-2
votes
1 answer

Report framework for Angular 6

I need to integrate Oracle BI (Oracle business Intelligence) reports with Angular 6. Does Angular 6 supports this integration or Any other reporting framework which should be used for integration with Angular 6 framework?
Teena Ashar
  • 11
  • 2
-2
votes
2 answers

Performance Testing of OBIEE application?

Following parameters should be set for OBIEE Presentation Server only during load testing. OBIPS\instanceconfig.xml save and exit file Restart OBIEE processes using OBIEE EM console. …
Nikhil
  • 393
  • 1
  • 6
  • 25
-2
votes
2 answers

How do I extract a part of a string and cast it into an integer?

For Example - If I have a string as mentioned below :- Summary: Start Volume (monthly) = 2 End Volume (monthly) = 0 Volume Reduction (year) = 13 Efficiency Gains = 100 Log: 09/13/2017 I just want to show the value of Volume Reduction in a column.…
Sanjukta Ghosh
  • 11
  • 2
-2
votes
2 answers

CASE with IN clause

I have a condition (in Business objects ) as below =If([Actual ]=0;Sum([Applied] In ([Project];[ Name];[Number];[Sub ]))) which I need to convert it to CASE statement for my OBIEE Below is the query I had tried but it doesn't work: SELECT CASE…
user1838000
  • 275
  • 2
  • 14
-2
votes
1 answer

OBIEE :Creating Dynamic Dashboard objects based on Input in Dashboard Prompt

Based on the input given in my dashboard prompt,the number of dashboard objects that should be displayed on my dashboard in OBIEE will be varying. How should I handle this case?
srinath
  • 31
  • 1
  • 4
-2
votes
1 answer

Using PL/SQL in ODI or OBIEE?

I have one question, in which step we can use PL/SQL in Oracle Business Intelligence: the ELT ODI or in OBIEE, and for what exactly? Thank you in advance
salma
  • 171
  • 1
  • 1
  • 10
-2
votes
1 answer

Requirements before jumping to OBIEE 11.7g

I'd like to know your opinions here, what tools do I have to learn first before studying OBIEE for ex. "Oracle Database" do I have to need a prior knowledge in Oracle Database in order for me to learn OBIEE in fast pace. I need your suggestions…
Voj
  • 51
  • 1
  • 11
-3
votes
1 answer

Is OBIEE free? and what are system requirements?

Is Oracle Business Intelligence, v. 11.1.1.5.0 free to install? What are the system requirements for installing?
sam
  • 451
  • 3
  • 10
  • 20
-3
votes
1 answer

How will you get 2,3, and 5 letter of first name and concat it with 2,3 letter of last name to make a new column named LETTERS OF NAME?

For example, you are given a requirement to create a column based on the following scenario: Get letters of FirstName Column (2,3,5) CONCAT with letters of LastName column (2,3) to create a new column "LETTERS OF NAME". P.S solution could be in SQL.…
user3323487
  • 61
  • 1
  • 1
  • 10
-3
votes
3 answers

Extract equivalent HOUR of a Time duration

I have the following date field format: "HH:MM", which represents the duration of an event, and I'd like to extract the equivalent value in HOUR (example: 2h:30min ==> result : 2,5 hour).
Rida
  • 1
  • 2
-3
votes
2 answers

Need suggestion on strategy to handle informatica error "value larger than specified precision allowed this column" as it is causing repeated failures

We are facing Informatica ERROR "ORA-01438: value larger than specified precision allowed for this column" again and again due to incorrect value entered by user in source system (Oracle EBS). What strategy we follow currently is: Informatica ETL…
Swarup
  • 1
-3
votes
1 answer

How to identify different patterns of numbers in a column?

I am trying to write one single formula to identify all the patterns in a column/field. For example: Below are the five different patterns AG 5643 895468 UWEB 7546 695321 IJJK PE 45612384 8642567921 16724385 Formula for First pattern: Contains 4…
Sarmistha Jts
  • 1
-3
votes
1 answer

Integration obiee 12 c with a GOOGle map

I work with obiee 12c, could you say me where do you write this code for javascript api, I don't know where use them
marwa
  • 1
1 2 3
…
51
52