-
Remove version number from OBIEE logon page
how to remove version number from OBIEE logon page. which file modified.. please help me ..
-
OBIEE 12c Data level security
Hi, What is the best workaround to implement data level security since we are not able to view our newly created application role in RPD. TIA
-
When Exporting to Excel, number of rows gets reduced with an "X" logo (OBIEE 11.1.1.7.140715)
Hi guys, When I am doing exporting of data after having operated a query, I noticed a few errors. The data comes out messed up like this; in OBIEE, I get 6,000 or so entries, but here, I only get 3,865, with a noticeable 'X' here. Can anyone advise on what has happened and how I can mitigate this? Thanks!
-
Navigating Catalog Manager Using Java App
Using OBIEE 11.1.1.7 with client tools installed. I am trying to create a java app that allows a user to select an object from Catalog Manager. I am not sure which library to use to access the catalog manager's folders and objects. Any help would be appreciated. Raymond
-
OBIEE 12c - Data Cache not populating
Something is behaving differently for me between 11g and 12c in terms of caching. Can't quite figure out what it is. Running OBIEE 12c on Windows 2008 Server. I see ENABLE = YES in NQSConfig.ini. When I'm connected to the repository in online mode, Manage>Cache is available, so caching is, in fact, enabled. All tables in…
-
Select Distinct on a join?
Hi, Here is the problem. Fact Table - X contains dollar amounts, it joins to Dim - X table by RowID = RowID. In certain instances, the Dim - X table repeats the same RowID, because some of the other columns in Dim - X are different. In these certain instances, the dollar amounts from Fact - X are multiplied buy the number…
-
Invert OBIEE Pivot tables
Hello Friends, Is there a way to invert the OBIEE pivot table i.e. the facts to be in the left hand side and the dimensions in the right hand side (like a mirror image). We need this to implement some dashboards with Arabic content so that they can read it from right to left. Thanks for the support in advance. Regards,…
-
unable to login rpd online
Hi Team, Not able to login RDP in online mode throwing below error able to login in offline mode and able to login EM and console also OBI Version: 11.1.1.5.0. Can any one suggest on this Login failed due to : [nqs error:43113] message returned from OBIS [nqs error:43126] Authenticated failed invalid username/Password.…
-
OBIEE10g Rows with NULL facts
Hello , I am using OBIEE 10g, and by default the product is not showing rows which have all facts = NULL I need to show all rows regardless. any idea ? I have found a solution on 11g but not 10g could you please help me ? Thanks Himaz
-
Operator on Measure dashboard Prompt
Hi, i would like to put condition like Equal to, less than, greater than on measure dashboard promt. anyone suggest me simple way how can i do this?
-
Migration issues for mapview reports in OBIEE 12c
Hi All, I had migrated OBIEE from 11g to 12c. Everything is working fine except map view reports. I had given 11g spatial data source connection in 12c mapviewer (http://localhost:port/mapviewer). Please let me know the process for post upgrading map view reports. Thanks in advance. Regards, Suman
-
Deduplication of Rows
Hi, I have the following columns and the situation. Total Customers: (Count distinct of cust no) channel Values below Internet = 1 , null branch = 1, null mobile = 1, null my report is 1) month, total customers 201510 7000000 when i run another report with Channel Type (case statement) with Month and Total Customers case…
-
OBIEE 12c Data Direct ODBC Drivers
After looking through the documentation and the forums, I couldn't find the new location for defining which version of Data Direct drivers the BI server uses so I am sharing my results here. We were getting ODBC errors when querying a SQL Server 2014 with the 7.1.4 drivers that came with the default OBIEE 12c install. To…
-
OBIEE 11g integration with Sharepoint
Hi, Can anyone please let me know the steps for integrating OBIEE 11g with Share point. Thanks In Advance Siva
-
OBIEE 12c Custom Links on the Toolbar
This is not a question. It is provided as information for those who have added custom links to the OBIEE toolbar in 11g and need to know where to place the customlinks.xml file in 12c. 1. I placed these same three lines (from 11g) into instanceconfig.xml within the <ServerInstance> section: <CustomLinks>…
-
How can I view the "active" OBIEE 12c repository in read-only mode
After using the data-model-cmd.cmd batch file to upload an RPD, that rpd becomes a sequentially numbered file in this directory: "C:\Oracle\Middleware\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations And I presume that the new sequentially numbered file (such as liverpd.rpd_2) is now…
-
How to capture Login ID in Reports
Hi Gurus, I have a requirement like I need to capture the SSO of the user in Report of OBIEE11g please find the below screen shot for reference Please provide your inputs
-
How to delete the users folders in the Catalog/System/Security/Users folder
We recently migrated to 11.1.1.7.XXX version and we have manually deleted the users from the catalog and migrated. In that process we see a lot of users files also in the path Catalog/System/Security/Users folder, but we don't want to delete them manually because as it would raise any other permissions/ security issues. We…
-
OBIEE link on left menu only works with IE, not Firefox or Chrome
Hi, As described at : OBIEE 11g - Adding Custom Links With Icons - Red Stack Tech we created some links in the left menu. Our problem is that when this link target is a Windows folder, it only opens up with IE. When we use Firefox or Chrome, nothing happens, the folder window doesn't show up. Any idea why? Thanks
-
How can load/custom a new Skin/style in OBIEE 11g
Good Afternoon; I want to know the procedure to customize the OBIEE 11 g of the company that actually have two styles: FusionFx and blafp. Reading many articles I have seen that there are several ways to change the style, colors of the template, change background color in a dashboard, load a new skin.. but i need a…
-
How to query and make general dashboards with BSO cubes
Hi community, Does someone have general information on how to make dashboards and repository with bso cubes. We have made some dashboards with some aso cubes but we don't even know how to make data show up in an analysis with bso cubes. We really don't know much about the difference between these cubes types. Any help or…
-
OBIEE 11.1.1.7 installation
Hello , Can some one help me with Obiee 11.1.1.7 installation document from scratch. which includes creating oracle account creation in unix
-
Web Catalog upgrade from 11.1.1.6 to 11.1.1.9 fails
Hi Experts, I have recently installed OBIEE 11.1.1.9.0 version and then upgraded to 9.16v by applying the patch. My catalog is on 11.1.1.6.11v and when I try to upgrade my catalog thru the instance config file upgradeandexit tag, it fails. The presentation services do not start up and when I check sawlog file I see the…
-
Using Essbase filters to restrict access in OBIEE dashboards for multiple users
Hi, Need to use Essbase filters to restrict access to data in OBIEE Dashboards so that users with no acess to particular members are not able to see any data for multiple users. Any suggestions on how to go about it. Thanks!
-
Moving objects from one business model into another in OBIEE RPD
I want to move logical dim and fact tables from one business model into another business model with in the RPD. I am able to copy and paste the logical tables into different business model, but Joins and Content levels are not copied. Please share your ideas how to do this.
-
Week number configuration
Hi, There is a reporting requirement for weekly report and we are using the obiee week number functionality. The way obiee calculates week is from Sunday to Saturday but our requirement is to calculate week from Monday to Sunday. Is there any way to change that in obiee or do you recommend any other solutions? Thanks Julie
-
OBIEE 10g - repository merge help
Hello, experts. I'm hoping that you may be able to help me with details of a repository merge. Specifically, I'd like to bring in only particular presentation catalogs from one repository (repo B) into the other repository (repo A). I'd like to keep repo A as it is -- all objects (presentation, BMM and physical) remain the…
-
where does precitions save in file system
Hi, when i move reports, saved decimal settings are not moving. can anyone tell me where those setting would save for reports?
-
How to calculate top 100 in obiee 11g analytics report?
Hi, I am creting analytics report in obiee 11g. I have 5 columns branch, district, outstanding balance, loan status, loantype. I want to display the data of above 5 columns in the analytics report.. For this report, i want to add custom rows.. My requiremt is, I want to dispaly the top 100 outstanding balances, total…
-
what does refresh option does
Hi, i would like to know what does refresh option does on botttom of the dashboard report in (export options)
