-
Formula syntax is invalid
Hi, I have just started working on a new OBIEE environment 11.1.1.9... and when we have an incorrect formula in an answers formula column I just get the message - Formula syntax is invalid. On every other environment I have worked on I also get a bit of info about what the error is. Does anyone know if this is a logging…
-
How to identify all analyses using a filter that is based on the results of another analysis
How can I identify all analysis in the catalog that contains a filter that is based on the results of another analysis? Due to limitations on TimesTen, we need to remove all instances of the filter based on another analysis functionality completely.
-
OBIEE 12c Hardware Requirements
Experts, In the coming weeks, I'll be responsible for standing up OBIEE instance for 500+ users. I'm familiar with BI development, but I've never installed it or spec'd out the servers. I've searched MOS, but I don't see anything that gives guidelines for the architecture. How should I spec the servers? The instance will…
-
Can't login visual project after migrate from 11g to 12c
Hi all After migrate from biee 11g to 12c, can 't login visual project va, Get error ：Error. Could not sign you in. Please contact your administrator. Does anyone know how to resolve this issue？
-
How to pass the presentation variable value from OBIEE in a URL
Hi All, Can you suggest on how to pass the presentation variable value from OBIEE in a URL ? Thanks!
-
OBIEE 11G ANALYZE permissions
Hi All, How to give analyze/edit permissions on some of the dashboards to the users? Thanks R
-
New installation of Oracle BI EE Client on Windows 7 machine. Database opens in "Read Only" Mode
I installed Oracle BiEE 12C client on Windows 7 64 bit machine. I installed the instant client as well. Everything looks right except with I open in online mode I get a "Read Only" version of the database. I am unable to import metadata. Does anyone have any suggestions? I repeated the installation using an 11G client and…
-
dynamic file name in ibot
Hi, had anyone able to use the agent to send file for dynamic naming convention. i.e. FILENAME_SYSDATE, FILENAME_021816.XLS??? Thanks in advance!!
-
Passing OBIEE Dashboard Prompt values through URL(to Hyperion Financial Reports)
Hi All, We have a current requirement to open Hyperion Financial Reports(FR) URLs from dashboard using the OBIEE dashboard prompt values as selection for FRs. We have done some registry changes in the action config file in OBIEE to invoke EPM action agent but without any success. <?xml version="1.0" encoding="UTF-8"?>…
-
how to change Email Subject Name Dynamically based on prompt values in BI Publisher while Scheduling
Hi All I am scheduling a BI Publisher report in OBIEE11g. The report is having Month Prompt eg. APRIL-2014. While scheduling the Report, can we take this Prompt Value inside the Email Subject Area dynamically? For Example, The Email subject is "Region wise Sales". But User wants to have the Email subject like "Region Wise…
-
BIEE12 - Migration failed Import in BIEE12 RDP Transformation failed
Dear Experts In my attempt to migrate to BIEE 12 an application of BIEE 11.1.1.7 got an error when importing the file. Error: == bin]$ ./migration-tool.sh in /u02/ofm/12.2.1-obiee/WLS/user_projects/domains/bifoundation_domain/bitools/bin/Exp11to12v3.jar ssi Oracle BI Migration Tool Logging to:…
-
Unable to login obiee12c analytics with weblogic after done the active directory authentication with
Hi All, Could you please provide me the solution for this. after done the MS-Active directory authencation with obiee12C i am unable to login the obiee analytics page with weblogic user where as i am able to login console and em. Can any one pls let me know solution for this. Thanks, Yogi.
-
Change setting for all users?
I am trying to change the default value for "Prompts Auto-Complete" in the my account setting for all users. According to the documentation, the <SupportAutoComplete> tag in the instance configuration should allow me to change the default setting to "On" for all users. However, that didn't work, all users still have "Off"…
-
Query time limit based on subject area query
HI, i would like to know if I can setup query time limit based on subject area. some subject areas I want 15 mints and some I want 20 mints And some unlimited. i Want to cancel the query if the query crosses more than 15 mints Or 20 mints. where do I need to setup this
-
Can't set user starting page when upgrade from 11g to 12c
'Hi gurus, I have a problem after upgrade from 11g to 12c, user can't set starting page, when setting starting page, i can choose the dashboard page, and save did't get error.but after logout and login, the starting page didn't work. The starting page of my account is default. Pls help.
-
Union with presentation variable values not passing into Drill through page???
Hi All, Issue Summary: Obiee union report column formula (case condition with presentation variable) values not passing into drill through/detailed page. Environment: Tested in latest Obiee 11.1.1.7.160119 and also tested in Obiee 12.2.1.0.0 (Build BIPS-20151008013645 64-bit) Issue Detailed : Formula with presentation…
-
OBIEE 12c cluster installation
Hi All, I want to install OBIEE 12c in cluster environment with horizontal scale out.Can anyone provide me the installation guide/steps ?I have tried install in stand-alone environment but i am bit worried about cluster configuration steps.I didn't any step in the installation process which can differentiate stand-alone…
-
Rerun [migration-tool] import BI 11g to 12c
Hi Just curious if anyone has successfully re-run the migration tool for an import. I accidentally exported-imported from the wrong 11g system. It's no big deal so if we have to go back to square & rerun RCU etc & do a complete start from scratch we will likely just skip it as we are just doing a pilot trial at present.…
-
Dashboard prompt between 2 different date columns
Hi all, I'm trying to create a Dashboard prompt that will allow the users to filter the report based on 2 different date columns. We have an open date column and a closed date column. I want to allow the users to pick an open date and then a closed date that is at a later date. How would I go about setting this up? Thank…
-
No ODBC system data source is defined for oracle BI server in OBIEE 12c
OBIEE client tools installed on Windows 7 64 bit does not create a working Oracle BI server driver ? It gives me various errors like
-
Where is the /res/v-0YH2UYTNo3k/s_Alta/master/oracle_logo.png
Dear Good Morning Analyzing the page element, I found the file path I search the directory ( analytics/res/v-0YH2UYTNo3k/s_Alta/master/oracle_logo.png ) but can not find it on the server. How to find out which is the correct file? There is some sort of change with environment variables? If yes commotion I find out? Thanks,
-
Installing Oracle BI Client only on single Windows 64 bit laptop
On the download page for BIEE I am instructed to install JDK, Webserver, Oracle BI 12C and Oracle BI Developer Client Tool. To my mind this is the server installation package. I only want the Client Tool. Can someone clarify this for me? I know this is pretty simple but.....I still need an answer. Thank you.
-
Difference in path of measure mapping
Hi guys. I noticed difference between mapping in measures like this: In first example there is full path from database but in second only the column from BMM. Could you tell me what is the difference in action? How can I affect on that path?
-
How to get maximum & minimum date between 2 dates in OBI
Hi All, I have 2 date field StartDate & EndDate. Now I want to take maximum date between those 2 dates. Is there any function which I can use to derive that value. Note: This OBI is an inbuilt system which coming with Oracle Sales Cloud. So I don't have access to repository and all. I have access only to the available…
-
OBIEE 12c - Range-based LTS fragmentation not working for me
Working with OBIEE 12c. I am attempting to implement range-based partitioning of my fact sources, but not having much luck. I can easily implement value-based partitioning, and it works just fine. For instance, my two fact sources have these fragmentation formulas: (1) "Mavu_Biz"."Times"."Term" in…
-
Time Series Calculation Functions don't work
Hi, I have question about Times Seriec Calculation and Time Hierarchy. When I use AGO function, the results not show. My formule for AGO is: AGO("Fact_OM_DATA"."SOLD_HOURS", "TIME"."Dim_XX_W_CZAS_DDim"."Month", 1) And I don't get any error with bad syntax. Therefore, I think it's a problem my time hierarchy. My Time…
-
OBIEE 12c - Activate Repository - Not retaining System Logging Level
Can someone check me on this in OBIEE 12c? 1. Open repository in online mode 2. Change system logging level to 2 (Tools > Options > General > System Logging Level) 3. File > Copy As 4. Save RPD under a new name. 5. Open that new RPD in offline mode. 6. Check the system logging level - should still be 2. Mine is. So far so…
-
Setup OBIEE 12c on AIX 7.1
I am getting the below error when running the configuration tool: I'm running AIX 7.1 and 12c DB with 1 pdb. Any assistance??? [2016-02-14T13:44:52.048-06:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 62] [ecid: 0000LBXH^Eb4Ax^_xT1FiW1MkDP9000004,0] Failed single shot step: Add default service…
-
Condition not working on Measure column
i have a measure column.on that column i want to display 'Do not consider' text instead of value if the absolute value is greater than 100. Because of differences in data types its throwing error. anyone suggest how can i display Text 'Do Not Consider' if the absolute value of measure column is greater than 100.
-
Connecting OBIEE Admintool to Hive : issues with ODBC. Any option ?
We're facing a blocking issue when trying to connect Admintool to a Hive instance by using any ODBC driver. For a POC we're trying to setup a Hive subject area to be analyzed in OBIEE. Everything seems to work OK until we try to load the metadata. In this case, the schema is found but no table under it. We can add the…
