Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Cloud and Server
Ask questions in the Oracle Analytics Cloud and Server forum to get immediate help from peers and experts. Collaborate on best practices and dive into discussions around Data, Analytics and AI.
Discussion List
-
Need to display both numbers and percentage on OBIEE Report 12c stacked Bar chartHi Team, We are in need of displaying both numbers and percentage on stacked bar chart (OBIEE 12c). Could you please help us how to achieve this? Below is the sample cha… -
Can a filter be applied to a result column?I created a union between two subject areas and performed some calculations as part of one of the result columns. I would now like to filter based on the output of the r…
-
Is there a way to show specific columns when exporting?Our reports have lots of columns but is there a way to limit the number of columns or specify which column to be included when we export? Thanks Joe
-
How can I display both number and percentage data markers in a bar graph in OBIEEHi Team I want to display both the numbers and percentage value in a stacked bar graph in OBIEE As of now I have the Show Data Labels option to "Always" and data format …
-
Different Format of values in table prompt column at AnalysisHello Experts , If I select all values in one table prompt column (BI Anaswer, OBIEE 12.2.1.4), I see it in Blue colored and large font: However for other value it is pe…
-
Oracle 12c database compatibility with OBIEE 11.1.1.7.140527Dear Experts, Our OBIEE version is OBIEE 11.1.1.7.140527 and database version is 11.2.0.4. We are planning to migrate/upgrade to version 12C. However, we couldn't find a…
-
Layouts at Dashboard related queryHello Experts, I am getting reports in dash board like below: Please see report lay out is shrink-ed and I need to scroll to see further data. I need some thing like bel…
-
I am wondering why "Date Of Birth" column value is populated for aggregated row "Snapshot Month" asHello Experts, I am wondering why "Date Of Birth" column value is populated for aggregated row "Snapshot Month" as well. BI Answer (OBIEE 12.2.1.4): There is no aggregat…
-
Dynamic columns in Excel TemplateHi all, Is there something simillar to "for-each@cell" in excel template? In order to make dynamic columns like i can do with rtf template but in this case with an excel…
-
how to build a timestamp function to retrieve data from beginning of fiscal year to current dateHi Guys, I am looking for a timestamp function that will return data for the fiscal year period: 01-May till 30-Apr of every year as well as from 01-May of current year …
-
Preventing Download/Export for Specific Users in OBIEEWhat is the best way in OBIEE 12C to prevent or allow certain users to export certain analysis in a dashboard page? thanks
-
Store BI Publisher reports in a tableHello All, Currently researching a requirement for one of my projects where we want to store the pdf files generated by BI publisher as a blob column in a table. Can any…
-
Union request summing problemsI am creating a report with following columns: Market Code,Room Nights, Room Revenue, ADR, . ADR is calculated by Room Revenue/Room Nights. COR 5 450 90 IND 3 360 120 To…
-
How to remove the last three characters from a string?Hi Guys, On the column country in my report i am getting the country like Italy/RF. I need to remove the '/RF'. Tried TRIM, combination of SUBSTRING and LENGTH, but not …
-
How do I populate an ID field in the target table using an ODI interface?Here is my example. This is an 11g OBIEE environment. The CRAFT table is being populated from a source system into a table that includes an "identity" column that is pop…
-
How to count Web Catalog Objects?Hi, does anyone know how to count how many web catalog created inside OBIEE Instance? for example: how many dashboards created? how many analytics created ? how many BIP…
-
alignment of dashboard + hide view with no dataDear, I have two problems, 1-I changed the alignment of table and titles but the changes did not reflect when running the dashboard. 2-In my analysis I have three tables…
-
OBIEE Physical Diagram JoinWithin the Oracle BI Administration Tool, I opened my RPD file. I selected two tables in the physical layer, right-clicked, and selected Physical Diagram -> Object(s) an…
-
What is the usefulness of multiple logical level keys in a non-Time dimension?From time to time in different clients' RPDs, I find hierarchy levels that have multiple logical level keys (level-based hierarchy). For a Time dimension that makes sens…
-
Schedule data visualization report in OAS 5.5 stand alone vesionHi, i am trying to schedule DV report in OAS 5.5 stand alone vesion. But i don’t see option to schedule the report similar to analysis(answers) report. anyone suggest me…