-
OBIEE 12C SMTP Server Configuration
Dears, i am trying to configure smtp server in obiee and for test i am using gmail.. after creating agent and devices to account who i want to sent the analysis to the following error is showing: [nQSError: 75025] Handshake failed when connecting to SMTP server using SSL. any advice? BR Bassam
-
obiee 12c Title view,need syntax for adding days to a presentation variable
Hi Gurus, Please see below the scenario. I have a simple report with a title and table views. The report is run using a "from_date" presentation variable passed from the dashboard prompt. My title view should display date value which is "from_date" plus 6 days. For example: if my dashboard prompt passes value of…
-
Cross Drill level based measures..
Hi, OBIEE 12C version - 12.2.1.4.0 I have set of reports which uses measures from two different Fact tables (cross drill) . Both Fact tables have two dimensions in common (Time--> Date key level & Geo Location). There is another Dimension exists in both Fact table but at different levels one Fact is at SKU level another…
-
Report is taking time in OBIEE
Hi, OBIEE report is taking time to generate result. I have checked from the backend and S_NQ_ACCT table DB is taking time around 3 minutes and report is generating in 20 minutes. Can you please let me know if we can restrict that in OBIEE side. e.g. If any report is running more than 5 minutes from OBIEE side it should get…
-
Dayly and monthly measure's in one report
Hi all i gather dayly 1. measure's (fact_dayly_measure) (id_employee,date, measure1,measure2) 2. fact_dayly_measure coonect with Employee , so in one day- all Emloyee with many attributes, changed day by day 3. fact_dayly_measure connect with Calendar So i need now add Plan_monthly_table that consist monthly plan for…
-
Error loading a dynamic table from OBIEE in view designer of Smart View
Using the option "Load view in view designer" from the Excel we have been able to insert the dynamic table created in OBIEE,the same doesnt work with PowerPoint and returns the below error, "InvalidArgument = The value of '1' is not valid for 'SelectedIndex'. Parameter name: SelectedIndex " Quickly wanted to check if…
-
BI config launcher not opening
Hi All, I am trying to do BI config using config.sh.But launcher is not opening and showing below error in logs. >>>> Could not execute /tmp/OraInstall2019-03-28_02-03-49PM/install5836877102602167016.sh Please advise.Thanks! Regards, Ramarao
-
Timestamp functions in Smartview environment
Trying to use TIMESTAMP funcitons in OBIEE using Smartview as the method for updating the table. It works fine the first time I execute Smartview, but on subsequent refreshes I get a string of zeros returned. Any insight? I must be doing something wrong.
-
Default report format output
Summary Default report format output Content I have a link that I created that links an OBIEE report to a BIP report using go URL. In the example I followed the report output is PDFs. PDF is defined towards the end of the go URL as follows: &_xf=pdf&_xautorun=true. If I want the default format to be Interactive format what…
-
Column value missing when creating Action for navigate to web page parameters
Hi All I am using "Oracle Business Intelligence 12.2.1.3.0" when I tried to create action for navigate to web page and add parameters, column value is missing, I tried to find the solution but unable, as I remember this option was available in 11g anyone please guide me Fig.1, Column value is missing from the value list o
-
OBIEE 12C Reports Export not showing Arabic Characters
Dears, We are working on OBIEE 12C and while trying to print out the report or export that report instead of showing the arabic character it is showing ????? so please any advice? Best Regards, Bassam
-
Multiple Oracle Home after upgrading OBIEE12c and applying patchset
Hi, Currently we are upgrading the OBIEE version from 12.2.1.1 to 12.2.1.4. Bit of history over the period of time we have moved from 10g to 11g and to 12c. Directory structure before upgrading the OBIEE from 12.2.1.1 to 12.2.1.4: Oracle_Home : ../oracle/product/Oracle_Home Domain Home:…
-
Export Issue for OBIEE reports where rows is more than 65000
We have an OBIEE version of 12.2.1.4 in linux server where most of the reports fetch data more than 65000. We have raised an Oracle SR where they have proposed the following solution : <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB> <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing> </XMLP> also in…
-
Oracle Data visualization training
Summary Need to find out training of Oracle DV, either online interactive or face to face class room workshop Content hi, is there any interactive real time online training or class room workshop for Oracle Data Visualization ? any expert here could organized a training ? It would be really helpful and much more easier for…
-
Refresh other parameters on change - Needed for Parameters with the Date Type
Summary Trying to find if there's an option for refreshing other parameters with Date type Prompt Content Hello Gurus, We've a requirement in BI Publisher that has 5 Prompts. One of them is DATE and the remaining use SQL for LOV. We are doing cascading for 3/5 prompts. The cascading or inter dependency is on the first two…
-
OBIEE 12c - BI Server generating ROW_NUMBER() in query
Hi All, I am using sample snowflake schema, while creating report BI generating ROW_NUMBER() over on each column. kindly suggest how to avoid/disable this?? sample query select T81504."ACC_OPN_DT" as c8, T81504."PROD_ID" as c9, T81504."CUST_ID" as c10, ROW_NUMBER() OVER (PARTITION BY T81495."SEGMENT_OWNER", case when…
-
OBIEE12.2.1.4.0 - Minimum version of Acrobat Reader that can export data from Analysis / Dashboard /
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux. In our rollout plan , we want to standardize a version of Acrobat Reader in order to avoid issues with users having different versions of the Acrobat Reader. We are trying to find what is the min version that will allow successful exports in PDF format in OBIEE 12.2.1.4.0…
-
DVD / Hive & Tez
Summary DVD / Hive & Tez Content Hi, how can i choose to use Tez (and not map/reduce) on a hive connection in DVD (or OAC) ? Cdt
-
OBIEE 12C Direct Database Request with variable
Hi, I am trying to make a DDR from OBIEE 12C i.e select * from STTM_CUSTOMER where branch_code=:br where br should be a variable or command prompt as it is used to work in toad and sql developer and i am getting the following error: View Display Error Error generating view. Error getting cursor in GenerateHead Error…
-
OBIEE upgrade to 12.2.1.4. Problem with Readiness Check for one of the schemas
Hi, I'm trying to upgrade OBIEE 12.2.1.2 to 12.2.1.4. I have installed FM in new Milddleware/Oracle_Home. I have installed new OBIEE in the same location. Next step is to run Upgrade Assistant in readiness check mode. You need to provide path to the older version and provide details about all used schemas (DB user name and…
-
Data Sync Moving Updates/Changes from Dev to Prod.
Summary Data Sync Moving Updates/Changes and New FACT/DIM tables from Dev to Prod. Content I am looking for documentation as to How-To move Updates,Changes (New FACT&DIM tables and altered tables) from DEV to PROD. The PROD was set up and has some tables in it but a lot of changes and additions have taken place. Thanks…
-
Oracle Data Visualization Dataset readonly?
Summary New dataset created via SQL Script read only? Content Team, I created a new dataset using SQL Script from tables in my WareHouse. DV will not allow me to alter the formatting on the columns (format date,). See the image. Yes, I have full right and I can go to other datasets and alter them. Suggestions. Version…
-
OBIEE 12.2.1.4.0 Catalog - Can the information displayed be restricted
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux . On the Catalog screen, on the right pane we can see the objects and some additional information like last modified timestamp & who the object owner is . How can we restrict this information so Only the object name (Sample Sales Lite ) is displayed. Also, there is an icon…
-
Temp space is very lage
Hi, We have installed OBIEE 12c in linux environment. And in \tmp mount point we have only 10 gb space. But in s_nq_acct table there is one column called Total_Temp_KB which is having value something as 107gb. Can you please tell me how it is showing 107 gb. We did not change any temp path. Is there any default available…
-
tnsnames for OBIEE 12.2.1.4
This works for OBIS but for admintool does not work
-
How to create analysis base on two different dates
Hi, I must create analysis in OBIEE 12. I have CLOSE_DATE and NOTIFICATION_DATE as DIMENSION - I have three column: Year (YYYY), Month(YYYY-MM) and Date(YYYY-MM-DD) - for both of dimension. Next I have Facts with for example count on product_name called: # of products. I can create analysis (table) like: Close Month || #…
-
OBIEE installation
Hi Experts, 1) How do we can identify our OBIEE 11g installed on Enterprise only or Software only ? using software folders or anyway? Thanks in Advance
-
Correct syntax to modify column header?
I am fairly new to OBIEE and I am attempting to format my heading to add a dashed border rather than a solid border. I attempted to do so using the following settings: However, the border ends up being applied around the cell content (the heading name text) rather than heading cell border, so it's not really a border, but…
-
Hi, Migrating Catalog objects in OBIEE from dev-test-prod environments is a repetetive and tedious m
Hi, Migrating Catalog objects in OBIEE from dev-test-prod environments is a repetetive and tedious manual effort as there is no versioning that comes with the tool. I would like to know if there is any way to automate this migration process? I have been doing this monotonous task at least trice a week and I would like to…
-
Merging records from multiple data sets
Summary Merging records from multiple data sets Content Hi All I need some urgent assistance please. I have an xml file with the attached layout. This produced two records in my results as per attached. Refer results in excel file the first table. The second table of results in the excel file is what I want my template to…
