-
OBIEE Usage Tracking
Hi All, I am currently exploring OBIEE Usage Tracking report and wanted to check few things. There is a report which just gives 1 record and for most of the user the report run time i.e.Total Time Secs shows 1-2 secs. However, I also see an entry for some user where it took 650+ secs to show the result. The report cannot…
-
Info- OBIEE 12c Support Database
Hi, Please let me know if OBIEE 12c supports Sql Server 2008 R2, if not from which version it will support. Thanks Anirban
-
Adding a column to logical table or logical table source
Hi , Can anyone explain in which scenario do we add a column in physical layer to a logical table and in which scenario do we add it to a logical table source? Regards, Yaseen
-
loopback adaper
Hi, In obiee am getting loopback adapter issue. Some one deleted the loopback adapter. If I install loopback adapter is it work properly...? OBI-SYSMAN-1253> <Host: orabi-PC has incorrect network configuration; it is returning a loopback address as one of its addresses> and OBI-SYSMAN-1108> <Unexpected error configuring…
-
Google Analytics Integration into Datawarehouse (OBIEE)
Hello, I am looking for a help on Google Analytics integration into DWH system: 1) how to get Google Analytics (GA) data? 2) Any recommended APIs to get GA data into Oracle tables? There are 3rd party adapters in Informatica (https://marketplace.informatica.com/solutions/google_analytics_connector_for_powercenter) but I…
-
OBIEE 12G Mapviewer
Hi So i've been working on this on 12G, we have it working og 11G and everything is working fine. But when I try to configure a datasource in 12G, I can get it to work. I change the paramters for our datasource - and it is basicly the same as on 11G. So this should just work - right? It doesn't - whenever I try to modify…
-
Column Selector with Global Filter
Hi, I have column selector with: Week, Month and Quarter. I used them in Pivot Table. I want to interact this column selector with global filter. For example: When I choose "Time"."Week" I want to set global filter: DAY_NUM_OF_WEEK = 7 choose "Time"."Month" - > DAY_NUM_OF_MONTH = 31 choose "Time"."Quarter" - >…
-
Prompt Auto Complete Not Working properly.
Hi All, i have implemented prompt auto complete functionality for my dashboard. Using following link http://obieeil.blogspot.in/2013/02/obiee-auto-complete-prompts.html Auto complete is working but in some case it is not working like choice list contains value like "Bajaj" but when user type it is not display into…
-
How to open URL in a new tab?
Hi All, I have created a report something like this... ProviderWebsiteGooglehttp://www.google.comAmazonhttp://www.amazon.comEbayhttp://www.ebay.com Expected Result. ProviderWebsiteGoogle URLAmazon URLEbay URL Here I am trying to do two things.. 1. Hide the URL but give the hyperlink to the word "URL" 2. When user clicks on…
-
Unable to expand the catalog in OBIEE
Hi all We have a clients Obiee server crash so I am in the process of restoring everything at the moment. I have deployed the catalog, repo, application roles etc but I am unable to expand or do anything to the catalog online? (expanding the shared folders folder) When checking the permissions in catalog manager offline…
-
Displaying DFFs in OBIEE 11g Answers
Hi Gurus, is there a way to make DFFs available in OBIEE 11g presentation for reprting ? Ex. for Oracle Projects, we are trying to build a report that can show few Project Classification Codes based on Corresponding Project Classification Categories in a single row. Any input is highly appreciated. Thanks,
-
OBIEE dashboard column formula
HI, OBIEE 11.1.1.7 I am trying to update certain records (some fields, not all the line) in the dashboard depending on the entry from the presentation variable (drop down list) let's say the user chooses (A,B,C) from a list of (A,B,C,D,E,...) and i only want to update the Amt for those lines by equation= Amt *…
-
OBIEE 11.1.1.7.150120 Conditional Format Grand Total Row Pivot Table
I am having a difficult time adding conditional formatting to the grand total row in a pivot table. Whenever I add this code: <saw:conditionalDisplayFormats> <saw:conditionalDisplayFormat> <saw:formatRule> <saw:condition> <sawx:expr xsi:type="sawx:comparison" op="greaterOrEqual"> <sawx:expr xsi:type="sawx:columnRefExpr"…
-
Beginner OBIEE question, possible to connect to multiple Essbase cubes?
Expect a little bit of hazing being new to OBIEE and this is probably a dumb question... But I have 2 Essbase cubes, almost exactly alike but one cube has an additional dimension. Is it possible to have one dashboard being populated by both Essbase cubes? Thanks! OBIEE New-B
-
OBIEE GL Department Hierarchy Effective Dating
We are using Project and Financial EBS modules as source and OBIEE (R1213) for reporting. The GL process picks up the current project org hierarchy and posts GL based on that hierarchy and thus changing GL department hierarchy for almost every period. So when we run Trial Balance report the departments are off/missing from…
-
Error in Dropping columns from Subject Area to selected Columns section after upgrade to OBIEE 11G
HI, When we are selecting through standalone OBIEE URL I am able to drag the columns,but error is occuring it is producing “Uncaught ReferenceError: kmsgPickerUIJSCantAddColumns is not defined” when we open the OBIEE from other application and its replicating only after the OBIEE upgrade from 10G to 11G. Thanks in Advance
-
How to control Presentation object visibility dynamically based on Report Prompt?
Hi All, I got a new requirement which eating my brain out..... Suppose user gives Month Prompt value As 'APR', then I need to hide or disable certain measures in the Left pane of Criteria Tab, so that user wont be able to drag those columns for report. And also those objects should be enabled/unhide for a different…
-
Joins & mapping in LTS
Hi guys, Recently I'm dealing with following issue (I will simplify my model in purpose): I have one LTS "Points" which contains "points" measure and I have following report with 6 attributes and 1 measure: Partner1, Partner2, Transactions, Orders, Billings, Customers, Points. So when I enter "Points" LTS>General it maps…
-
Force OBIEE to hit partition table
Hi Team, I am currently using a fact table which is partitioned on YEARMO column at the database side. This is joined to WC_MONTH_D on YEARMO column. So my join condition is fact.yearmo=month.yearmo. Now I am putting filter on CURR_FISC_YEARMO column of wc_month_d. What I observed is it does not hit partition table unless…
-
Export as pdf in OBIEE 11g
Hi all, In dashboard page i wanna enable export as pdf for the customer , currently i can able to export to excel.. i have used html code for Excel , But i cant export as pdf , anyone help with this issue HTML for Excel: <a class="NQWMenuItem NQWMenuItemWIconMixin" name="pdf" href="javascript:void(null)" onclick="return…
-
Path is not found while trying to implement Logo & Skin customization in OBIEE 12C log in page
Hi Friends, Can any one kindly provide any link or document to implement customization of logo, skin & look and feel customization in OBIEE 12C. Not able to find "/web/res/" folder in 12c as like 11g where I could locate the file b_mozilla_4 file. Again Analyticsres folder is not able to find in 12c as like 11g through…
-
OBIEE Presentation Services not coming up on recreating BISystem Application Role
Hi Guys, I have accidentally deleted BISystem Application Role from EM Console. But, gone through couple of posts and recreated the Application Role and assigned the BISystemUser to the role. In a nutshell, I did the below steps. 1. Stop BI Service 2. Create a Role and member with BISystem User 3. Add the for policies for…
-
Conditional formatting for null values in pivot view
HI, i am having issue in pivot view with conditional formatting for null values. i have values like below In pivot view. A 100 B C 200 I Want to apply conditional formatting(total row to bold) for row B Even though corresponding value is null. anyone suggest me how can i get this?
-
It can install samples sales in a BIEE instance 12c?
Hi Experts, I already own a BIEE instance 12c running two months. Now I would like to deploy the samples sales (catalog, rpd and all the bar file). Where could download the sample files to the sales dowload? thank you
-
OBI 12C - Validations pre-migration to 12c
Hi All, We have a customer in Argentina that is considering upgrading to OBI 12c. They are in V.11.1.1.7., but first they want to validate some things: 1. They have Mobile Apps build in 11g, are those migrated to 12c automatically ? Do they have to have any special consideration on this point ? 2. They are having an issue…
-
OBI 11g - SQL query to locate all catalog objects that a specified role has permission
Hi, I would like to find a way to query via SQL to locate all folders and objects within the OBI catalog where a specified role or group has any sort of permission. Can someone point me in the right direction for that? Thank you, Glenda Reed
-
Merging different version BiApps RPD
I want to merge customized apps 7963 rpd with BI apps 11.1.1.9.2 rpd. Please suggest exact steps to achieve this. Thanks in advance. Ajit
-
BIApps and Tableau integration
Has anyone done a successful integration with Tableau for BIApps? What are the experiences and how does data security work? Have you tried to leverage the BIApps warehouse (SSO setup with EBS) for integrating with Tableau.
-
OBIEE10G - Portal is not coming up
Hi Experts, I am looking into an old OBIEE10G(10.1.3.3.2) installation implemented on IIS 7 on a Win Server 2008 SP2. The problem is OBIEE portal is not coming up when we type - http://localhost/analytics or start > All Programs > Oracle Business Intelligence > Presentation Services. I checked the following and found ok.…
-
How to handle time calculations in OBIEE ?
Hello, I have below case to be handled in OBIEE, could anyone please help me calculating total hours. Regards, Clinton
