-
Can a KPI be filtered by a prompt which has a "Between" or "Greater than" and not only "Equal to"..
HI I have few KPI's in my dashboard and I'm trying to force them to filter by a date between X and Y. I tried many ways but it seems as if the KPI and then the KPI watch list could meet only a filter which is equal to - for example equal to a specific date but not if it is between dates. Not like the behavior of regular…
-
BI publisher jobs fails randomly
Hi All, I'm facing an issue with BI publisher jobs that are failing randomly. The jobs complete successfully after it is manually resubmitted. The following is the error received when they fail. [2017-03-13T06:39:00.465-04:00] [bi_server2] [WARNING] [] [oracle.xdo] [tid: 74] [userId: BISystemUser] [ecid:…
-
OBIEE ibots issue
Hi Team, Can you please help me on this issue. The current issue is not able to find few users in the list while trying add it to agents ,even the same issue occurs when searching for the users while trying to assign any privileges Missing users are able to login to OBIEE and all they are LDAP users. When the same catalog…
-
How do I add a description word to a XML field (in an .rtf)
Summary How do I add a description word to a XML field (in an .rtf) Content The following syntax works: <?xdofx:if Description___Country_ID123='UNITED STATES' then '' else HarmonizingCode_ID234 end if?> I would like to know how to add the words 'Harmonizing Code'- right before the XML value shows in HarmonizingCode_ID234…
-
Dynamic Column data population in Excel Template
Summary Dynamic Column data population in Excel Template Content Hi, I have requirement to create a analysis batch analysis report in Oracle Fusion HCM R11 BI Publisher. Data XML contain Parent data group (Header data) as well as child data group (Lines). Child data group is dynamic in nature and should be sub lines data…
-
OBIEE 12.2.1.2 Create AdminServer, Managed Server and bi components
Has anyone tried to breakdown the start.cmd in OBIEE 12c to Windows Services. Considering the start.cmd handles all the processes and there is no more opmnctl. I am hesitant to use the installSvc.cmd and InstallManagedSvc.cmd etc.. commands. I am also sure there must be an order and delay needed. I cant find good…
-
OBIEE 12 C XML Error When value is not available in Database
where the user pastes in a list of item numbers into the Filter and if one of the items does not exist in Database, the report throws an XML error. Is that is a bug??? We are using Currently Oracle Business Intelligence 12.2.1.2.0 Suggest me if any work around. Thanks.
-
Can obiee filter hotspot words and count on them intelligently?
Hi experts, Can obiee have such function as below: there is a field with text type named NOTE, user want to a report which will display hotspot words and it's occurrence number in database records intelligently base on this field value. User could not predict hotspot words. Thank you!
-
Advance Analyitcs Install Error (Path Not Found)
Summary Advance Analyitcs Install Error (Path Not Found) Content I am trying to install the Advanced Analytics component with DVD and Getting the Path not found error. I have checked the directories, both the .jar and Java files exist as well. Any pointers on this?
-
How to have filter @ the Canvas level in a multi-canvas project?
Summary How to have filter @ the Canvas level in a multi-canvas project? Content How to have filter @ the Canvas level in a multi-canvas project?
-
passing presentation variable - date field error
Hi All, could anyone please provide some suggestion - I have a field in the RPD which is based on the to_date and it is to get the last day of the month 1)OPV Field - LAST_DAY(TO_DATE(TO_CHAR(TO_DATE(A.REC_CALNDR_PRD,'YYYYMMDD'),'MM/DD/YYYY'),'MM/DD/YYYY')) AS MONTH_ENDING 2). From the Answers it looks like below without…
-
OBIEE 11g Write Back Functionality Is not Working - Unable to update the data
Hello, I implemented OBIEE write back functionality in 11g, but unable to update the date through simple two column report. Followed all of the oracle steps from below Oracle reference. and double checked all the permissions across all layers. Insert column / box is not enabled to overwrite / update the data. Followed all…
-
Deploying RPD from Mbean browser in OBIEE 12.2.1.2
Hello, We have installed Obiee 12.2.1.2 OS : RHEL 6 we created scripts in obiee 11g which use to take care of our deployment process in obiee 11g. Scripts used to deploy rpd through mbean browser, now we are trying to see the compatibility of our old scripts with obiee 12.2.1.2, i wanted to know can we still deploy rpd…
-
Not able to save a change to column properties
I am currently not able to save a change the column properties for my Actuals column in my analysis. I have used an action link to navigate from my analysis to a Report. I am trying to check the box "Do not display in a popup if only one action link is available at runtime". However, after I choose OK in the window and…
-
Export RPD variables and definitions
Is there a way to export a list of OBIEE RPD variable names and their values? I tried using biserverxmlgen however the dynamic session variables are not showing up.
-
how to get scorecard color based on scorecard card ranges values?
Hi, I have created objectives, folders, KPI's for scorecard . But scorecard colors are showing wrong colour for values . If scorecard ranges between 0-25 then red , 25-50 then blue , 50-75 then yellow and 75-100 the green clor But following screenshot showing wrong color for values But i want to display score color as…
-
How to tabulate YoY sales with budget by given cut off month ?
Summary How to tabulate YoY sales with budget by given cut off month ? Content Dear all, Management want to have analytics with Year on Year comparison with a cut off month to compare sales revenue and budget. I tried using presentation variable and This is generated in BICS. Due to same year, budget is stacked in same…
-
Removing Blank Lines from an ACH rtf
Summary Removing Blank Lines from an ACH rtf Content The bank I am working with can only accept NACHA files in blocks of 10 lines. For this, I created a code that will allow the Placeholder lines to populate depending on the payment count in the ACH file. For example: If there is only one payment line in the NACHA file, I…
-
BI Publisher Bar Codes
Summary BI Publisher Bar Codes Content Hello, I need to create a barcode label on BI Publisher report. I saw on internet and downloaded the 39font style. I added that font to my computer. In the report I can see barcodes only on html view. Any none of the users can see the barcode even on the html view. Is there a way to…
-
Conditional formatting in XML rtf Template (want to format the cell to red color when total is < 0)
Summary Conditional formatting in XML rtf Template (want to format the cell to red color when total is < 0) Content Hi, I want to conditionally format the cell to red color when when the total is < 0. I used the below tag, it is giving me error "Caused by: oracle.xdo.parser.v2.XSLException: <Line 136, Column 100>:…
-
BI Publisher RTF template - totaling a calculated field
Summary BI Publisher RTF template - totaling a calculated field Content Hello, First and foremost, I appreciate any help I may receive. I am new to BI Publisher, our company has to prepare to leave Crystal Reporting behind and I have been teaching myself a bit. I have a connected query XML datasource that provides me with…
-
Link to PDF File
Hello guys, First of all, thanks a million for reading this thread. I really appreciate it. for all OBIEE master, I need suggestion and advices for my issues. For Example: let's say I have table in my analysis like this: Emp No is a link to PDF file if I click on Emp No then it shows PDF file as an Employee Profile. I need…
-
401 Unauthorized error while open the login page
Hi Team, we have OBIEE 11 on PROD SERVER and my some user facing a issue to access login page and for some user its showing 401 Unauthorized error and some time it is showing the web page to login. so we are exactly not getting the issue, why the some user can able to access or some not and the same user not able to…
-
Viewing the presentation services log (12.2.1.2)
I cannot view the log (for a request) when I go to presentation services Administration -> Manage Sessions. The response I get is "No log found" Where can I set the logging level?
-
Cloning Error - 'Essbase instance connection failed'
Hi - I am facing an issue during a clone attempt. The issue is occurring on the source instance, while trying to copy the instance configuration - I am following OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide (Doc ID 1625533.1). The error is thrown at step #4. At first, I tried this command with the above…
-
Catalog manager 12.2.1.2 error while performing search
Hi, We are in the process of upgrading from OBIEE 11.1.1.7 to 12.2.1.2. Everything worked fine with the installation, moving over the repository, copied over the catalog and performed "Scan and Update Catalog Objects That Require Updates" from the Administration tab. Installed client tools for 12.2.1.2 and connected online…
-
Get week of year, actual week and last week number - OBIEE 11.1.1.6.9
Hi, I have OBIEE 11.1.1.6.9 on analysis, I need get actual week of year and preview week of year to get table and alway sync when deploy report on pdf, because I need change each week filter on variable. On column / operator / values 1;2:3 If possible some query to get on filter variable. My screenshot Also I have special…
-
OBIEE Catalog Manager Special Character Problem
Hi, In OBIEE 11, I try to get catalog report by using Tools -> Create Report. However, turkish characters are problem in export file. Is there a way to correct this problem? Thank You
-
401 Unauthorized error while open the login page
Hi Team, we have OBIEE 11 on PROD SERVER and my some user facing a issue to access login page and for some user its showing 401 Unauthorized error and some time it is showing the web page to login. so we are exactly not getting the issue, why the some user can able to access or some not and the same user not able to…
-
Dynamic Grouping in RTF
Summary Dynamic Grouping in RTF Content Is it possible to have group by based of input parameter passed in XML for example user may pass to GROUP BY DEPTNO OR JOB OR AGE OR no GROUP BY at all.
