-
How to change date format in OBIEE?
Hi All, I have the date format in my DB as: '31-DEC-17' and the timestamp for for the same is: "31/12/2017 12:00:00" I need the date in the following format say: Jan'17. How can I achieve this? Regards, Dolly
-
Automatic Objective and KPI Creation from a table - OSSM
Dear all Is there some sort of script i can ran to create a KPI, and its respective value and target instead of creating one by one where you enter the description, then actual value and then the target? I already have these details in a table I am using OBIEE 12c Regards, Gibson
-
OBIEE 11.1.1.9
Hi, i have 2 application servers which are as below version. 1. obiee 11.1.1.7.+ 2. obiee 11.1.1.9 Is it possible to access both bi servers from one OHS domain? regards, wan
-
OAC - Enterprise Security Option?
We are looking at migrating to OAC (i couldn't find an OAC specific board, if there is one, i'd love a link) from OBIEE 11g. In 11g, we use our MSAD for authentication and would like to use that in the cloud. The OAC version we purchased does not include IDCS, which I know has the ability to sync to MSAD via an Identity…
-
OBIEE installation on Amazon RDS for MySql
Hi , Did anyone install OBIEE on Amazon RDS for MYSQL. If yes, could you please share steps followed for installation & configuration. Thanks, Sai
-
How to create one measure in logic layer
Hi Experts, I do not know how to create one measure in logic layer based on the business requirement(Count the customer numbers for one time during a period of time). It is very easy to write SQL in DB, but I do not know how to create model in Admin Tools. BusinessDate : Customer Order Date customerID : Customer ID…
-
Bi Publisher: Referring parent/child elements in xdofx
Summary Bi Publisher: Referring parent/child elements in xdofx Content Hi, I am trying to create an RTF template wherein a field value should use different elements based on a condition. I am using the below construct: <?xdofx:if SupplierNumber='XXX' then Name else AddressLine1 end if?> The elements Name and AddressLine1…
-
Displaying 100 columns in a BIP report online report
Summary Displaying 100 columns in a BIP report online report Content Can we display 100 columns in a BIP report? I have a requirement that I am working on to display about 100 columns in a BIP report embedded in a 3rd party app. The client is ok with horizontal scroll.
-
How do I create level based metrics in Data Visualization?
Summary How do I create level based metrics in Data Visualization? Content Hi, I have a dataset as below: LocationRevenueShop110000.0Shop22093443.9Shop310000.0Shop4102345.0Shop563086.0Shop66178373.8Shop76002296.0Shop81600.0Shop92050.0Shop1070701.0Shop1117020.6 I need to show the location that have less than 10% of total…
-
OBIEE 12c Application Role Auditing
OBIEE 11g Catalog Groups have been migrated into OBIEE12c WebLogic Application Roles.. (fusion middleware control - security - application roles) A: is there a way to grant users access to manage those without giving them full access to the rest of weblogic.. B: is there a way to audit who makes the change when a user is…
-
How to pass the value of variable prompt in analysis OBIEE
Hi Guys, I have created a variable prompt and have added 3 custom values in it. I have created analysis, and I want on the basis of particular value of variable prompt, corresponding analysis should be displayed. Can someone please give me an example, how to achieve it? Thanks, Dolly
-
Download link in obiee dashboard
Hi All, I have to provide download link in obiee dashboard page. Here download file path is different I mean it is some other source. Now file is downloading successfully but file name should show along selected date in dashboard. For example ABC_YYYYMMDD.PDF I am getting ABC.PDF as file name. Regards, SUDHAKAR
-
how to uninstall Essbase from OBIEE 11.1.1.7 stack
Hello, Due to licencing reasons, we need to remove unused Essbase component from the OBIEE stack. What is the best way to do that? It was installed by mistake and never been used. Thanks!
-
use ago, todate function dynamically
I have an alternative calendar hierarchy. One is for Gregorian calendar and another one is for fiscal calendar. The end user can report a metric using Gregorian calendar or fiscal calendar based on a session variable. I have an issue on how to decide hierarchy level based on a session variable. The following is an example.…
-
Oracle Redaction with OBIEE
Hello, We have a requirement in which we are to hide sensitive data (on the column level) from specific OBIEE users based on roles assigned in EBS. Our current setup: EBS (ERP source, holds all users) > Singly Sign On to OBIEE 11g (used for reporting). We want to mask/redact data at the database level. I know OBIEE stores…
-
Is there a way to give access to a report but not to the subject area
Hi All, We have a group of users who need to access a particular OBIEE Report, and we would like to give access to that user alone to Report not to Subject area. is it possible. Please reply the possible ways. please let us know if you require more information. Thanks, Chandra
-
How to filter to see only data in a data set not matching with data in another data set
Summary How to filter to see only data in a data set not matching with data in another data set Content Hi, I am trying to create a simple project to show me what are the cities without population. I have 2 data sets: one with 2 columns (city name, population no) and one with 1 column (city to find population). Data set 1:…
-
Total Hours : Manage Time cards (HCM)
Summary Total Hours : Manage Time cards (HCM) Content Hello Community, I need to develop a new BIP Report and I want to get the Total Hours (Manage Time Cards). Can you please give me the table name. Thanks for your help.
-
Need help to enable bursting by mapping parameters between Report and ESS Jobs in Oracle fusion.
Summary Need help to enable bursting by mapping parameters between Report and ESS Jobs in Oracle fusion. Content Hi Team, Is there any way we can map reports parameter with the ESS job for bursting so that it can selected dynamically while scheduling the job in Oracle Fusion. We have multiple parameters in reports Data…
-
Shortcuts in Catalog
Hello Experts, I am trying to explore Shortcut option in OBIEE , created shortcuts for Filter, Prompt and Report. Need your inputs , if the below assumptions are correct Though they are visible in Catalog , but Filter Shortcut is not visible during report creation and on the same lines Report and prompts shortcuts are not…
-
Default configuration for MaxVisibleColumn in OBIEE 12c
Hi Folks, Does anyone know what is the default configuration for MaxVisibleCol for Pivot table in OBIEE 12c? In OBIEE 11g, it was 100 by default. Whereas in OBIEE 12c, there is no TAG MaxVisibleCol as such present in Presentation Server's instanceconfig.xml file. Please help
-
BISQLGroupsProvider: SQLException querying groups
We are trying to configure a SQL authentication provider as described in: Configuring LDAP as the Authentication Provider and Storing Groups in a Database https://docs.oracle.com/middleware/12212/biee/BIESC/GUID-30F09EE4-A2DE-443D-BF24-CC401B6E13FD.htm#BIESC6128 We have completed all the steps, installing the JAR, setting…
-
OBIEE 12.2.1.3 Cluster
Hi, We have installed and configured obiee 12.2.1.3 cluster on windows OS. Start/Stop process takes a lot time approx 1 hour to restart all cluster and log file has following: WLSTException: Error occurred while performing shutdown : Error shutting down the server : Received error message from Node Manager Server: [Server…
-
How to avoid Fiscal Time repeating in table view?
Hi Community! I am trying to create an analysis that has Actuals, Budget and Last Year lined up by time metric. I have renamed column headers to separate the metrics I want to look at. However, the Quarters are duplicating (see screenshot below). Is it possible to have the results shown so the Quarters only appear once…
-
OBIEE 12c - how to calculate (and keep!) the value for the whole last year
Hi, I need help with a kind on cumulative calculation in OBI 12c. I have an analysis with euros in certain times: - month = certain month value - month YTD = cumulative from the start of the year - month YTD previous year = cumulative from the start of the last year, for comparison to previous column - whole cumulative…
-
Report Job does not delete with 'X' icon, even with workaround.
Summary Report Job does not delete with 'X' icon, even with workaround. Content I'm running BI Publisher 11.1.1 and when I select a report job to be deleted and click the X icon, nothing happens. I've tried the workaround listed in the knowledgebase (from analytics, query only the report job you want to delete and then…
-
Box and Whisker Charts
Summary Box and Whisker Charts Content Hi, I was wondering if it were possible to calculate and display box and whisker charts within Data Visualization v4 and how I would do this? Thank you, Simon
-
rtf template for Standard Purchase Order Stylesheet
Summary rtf template for Standard Purchase Order Stylesheet Content Hello! Does anyone have a rtf template for Standard Purchase Order Stylesheet? I need this for Customization of PO Output for Communication. Thanks!
-
Shortcuts in Catalog
Summary Shortcuts in Catalog Content Hello Experts, I am trying to explore Shortcut option in Catalog, created shortcuts for Filter, Prompt and Report. Need your inputs , if the below assumptions are correct Though they are visible in Catalog , but Filter Shortcut is not visible during report creation and on the same lines…
-
oracle.xdo.template.rtf.util.barcode.BarCode128 in rtf
Summary oracle.xdo.template.rtf.util.barcode.BarCode128 in rtf Content Hi I had previously implemented a barcode in XML publisher before the patch 9440398 was released at my previous employment and had to write custom functions code128a/b/c but looks like Oracle is supporting barcode128 a/b/c with this patch. I am unable…
