Reporting
Discussion List
-
How to implement Grouping of rows and adding back to pivot in DVSummary: I have a requirement where we have 2 attributes that need to be added based on logic and added as a third row in the visualization. Any idea if that is possible…SiddharthDang-Oracle 28 views 7 comments 0 points Most recent by SiddharthDang-Oracle Oracle Analytics -
Can we pass a value from one DV report to other with <= conditionWe have a requirement to drill from one DV report to other report. Report 1 and 2 have Accounting Date column. From report 1, we need to pass Accounting Date to report 2…Sahithi Kolasani-Oracle 49 views 8 comments 0 points Most recent by Sahithi Kolasani-Oracle Oracle Analytics -
Is there an option in OAC [Visualize Data] to get the filter value inside my calculation?Summary: Is there any option to use a custom date range in the x-axis of a bar chart rather than calendar month? User must be able to select the start date from filter a… -
Action Links not workingSummary: In the below report, I have 3 columns (2 with column selectors & 1 hidden), and one hierarchical column. The 2 columns with column selector are hidden by defaul… -
Calculated items in Pivot table in DVSummary: Is it possible to create calculated items in pivot tables in DV, as we do in classic? Content (required): Version (include the version you are using, if applica…
-
Geo JSON File For India's States, Cities and PIN CodesLooking for Geo JSON file which can provide India's State, City and PIN Codes spatial boundaries data. In the below link I can find India's State & City but I'm specific…SaurabhJaiswal-Oracle 41 views 5 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics -
Is Auto Apply Data option available for read only users alsoSummary: The 'Auto apply data' option in DV helps in selecting all the filters before applying which saves the resources by sending only the required query to database. … -
nQSError: 67020: One user is getting error while scheduling any reportHi, We are using OACS. One particular user is facing the following error while running agents: [nQSError: 67020] Exceeded max concurrent instances of scheduled job. Max …Ramprapanna Bhattacharya-Oracle 61 views 6 comments 1 point Most recent by SiddharthDang-Oracle Oracle Analytics -
CloudFish- cloud database direct query toolSummary: Tool for ad-hoc queries off of saas/cloud tables http://cloudfish.slpmicrosystems.net/ Content (required): I am using CloudFish tool without login into cloud PO…
-
Unable to connect to Oracle Analytics Mobile AppSummary: I am trying to connect to Oracle Analytics Mobile App. But it shows me the below error: It accepts the server url and asks for user credentials. But after provi…
-
BIP Report Alignment IssueIn the BIP report the alignment is coming up differently in different mail applications i.e. table alignment looks fine in Thunderbird but the same is misaligned in MS O…SaurabhJaiswal-Oracle 31 views 7 comments 0 points Most recent by SaurabhJaiswal-Oracle Oracle Analytics
-
How do I determine the source of an Analysis in a Dashboard?Summary: I'm reorganizing the contents of some Shared Folders. I need to update Dashboards to reference Analyses in new locations. Content (required): Is there a way to … -
How to disable users from printing and exporting analysis and dashboards in OASSummary: How to disable users from printing and exporting analysis and dashboards in OAS Content (required): How to disable users from printing and exporting analysis an…Sunil Gunturu-Oracle 61 views 11 comments 0 points Most recent by Sunil Gunturu-Oracle Oracle Analytics
-
OAC Connection with Oracle Cloud ERP General Ledger Balances CubeSummary: Has anyone tried creating a connection in OAC DV with Oracle Cloud ERP General Ledger Balances Cube? The requirement is to access a cube via OAC which currently…
-
How to get the list of columns being used in a DV ReportSummary: Is there a way to find or get the list of columns being used in a DV Report? Like we had a way to create a document with report name and the columns being used …
-
List of AgentsSummary: How can we get the list of Agent/iBots? In OBIEE we have BI Database Schema tables S_NQ_JOB and S_NQ_JOB_PARAM tables, from there we get the list including path…Subhakara Netala-Oracle 36 views 7 comments 0 points Most recent by Subhakara Netala-Oracle Oracle Analytics -
Blank e-Mail from Agent/iBot when there is no dataSummary: Getting blank e-mail from Agent when there is no data for the report on scheduled time. Is it possible to stop sending e-mail from Agent when there no data? Con…
-
OAC/OAS - Compress Report output (zip) with Agents DeliveryContent (required): Can we compress reports in zip format when delivering through e-mail from OAC/OAS. I understand in Publisher we can, however, my question is more tow…
-
Multiple Connection Pools for Usage TrackingHow can I specify multiple Connection Pools from different databases (In System Settings -> Usage Tracking) for inserting records into the Usage Tracking tables? I belie…
-
Default(System) font style in OAC 6.3I believe Oracle Sans UI is used as Default(System) font style in OAC 6.3 Classic, can anyone confirm this? Is there any document available?
-
Option to Remove/Hide "explore" link from OAC Classic dashboard for a DV reportSummary: Do we have any option to Remove/Hide "explore" link from OAC Classic dashboard for a DV report. Actually we want to Remove/Hide "explore" option so that users w… -
Image file display using OACSummary: We have a requirement to display image files in OAC. The files will be downloaded from Fusion using an API calls. We have the option to store it as a BLOB in DB…
-
How to hide Column in Pivot VisualizationSummary: In OBIEE, when you create a pivot and modify the properties of a column, you can make that column hidden. This allows the pivot to still sort/group by that colu…
-
List of physical joins in the RPDContent: Is there a way we can get the list of all physical joins defined in the OAC RPD? Repository documentation tool is giving lineage from physical layer till presen…Sahithi Kolasani-Oracle 12 views 4 comments 1 point Most recent by Sahithi Kolasani-Oracle Oracle Analytics
-
Dataset join with 2 subject areasSummary: Hi, I am trying to extend a subject area by creating a join between the subject area and a dataset (uploaded excel file). This works fine when the dataset is jo…
-
List of physical joins in the RPDSummary: Is there a way we can get the list of all physical joins defined in the OAC RPD? Repository documentation tool is giving lineage from physical layer till presen…Sahithi Kolasani-Oracle 1 view 0 comments 0 points Started by Sahithi Kolasani-Oracle Oracle Analytics
-
Attribute against forecasted value displayed as decimalSummary: In DV report , while building report ,attribute result showing decimal while data is varchar Content (required): HS2 Code which is the character data & having v…
-
OAC SUBJECT AREA ISSUESummary: I have a subject area with one fact and 5 dimension and 1 dimension being from other database Content (required): I am able to view the data in subject area whe… -
Subject Area is timingout when connected to in OACSummary: I have been trying to import the Workforce Profiles - Person Profile Real Time subject area into OAC, but it has been failing. Content (required): I want to sho…Praveen Kadiyala 21 views 3 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics
-
OACS : Moving AverageSummary: Hello, We are trying to calculate 5 day Moving average for Sales data. Sample data and expected result as below. We are using MAVG function of OACS. However we …