-
Timeout configurations in OBIEE
My users get timed out while they are working and have reverted to saving often. Where can I set/reset the timeout configurations in OBIEE? What are they typically set to?
-
Bind and Repository variables not passed to template in BI Publisher
When using one or more bind or repository variables SQL Standard Query of the data model of a report for BI Publisher we can see the values transferred correctly to the XML file created from the SQL Query, but they are not passed to the layout template in rtf edited on the MS Word 2010 application. Therefore it does not…
-
Export domain Mapping from OBI Config Manager
How do I export the domain mappings from Configuration manager to excel ? I do not see any feature on the front end. Any pointers will be greatly appreciated. thanks Jyotsna
-
obiee12c
Hi, obiee 12c configuration documrnt
-
OBIEE 12c Hyperion Planning connector - report on supporting detail?
We are using the new Hyperion Planning connector in OBIEE 12c, which is supposed to integrate reporting on the metadata from Planning. We were hoping to report on supporting detail entries, but we cannot seem to do this. We can report on comments from Planning using CellText member, but no luck reporting on the same…
-
Vertical Alignment of text
Hi All, I have a requirement to show the values in pivot view in vertical alignment or 45 degree alignment. I tried using Writing-mode: tb-rl; filter: flipv fliph; under Column Properties-->Use Custom CSS Style But there are multiple columns and the width of the column doesn't seem to adjust accordingly. Also this seems to…
-
Put a comma between city and state
Summary Put a comma between city and state Content Hi, I have a RTF template. Field contains 3 data: * City Name (variable length) * State Initials (fixed 2 Chars) * Zip Code (variable from 5 to 10 chars) I need to place a comma between city name and state Example: Source: <Address_ID30>Vegas NV 0000</Address_ID30> Result:…
-
EXCEL Template Conditionally Display the region
Summary EXCEL Template Conditionally Display the region Content Hi, Could you suggest on below. In .Rtf template we use below syntax to conditionally display the region, how to achieve this in EXCEL Template? <?if:COLUMN_NAME>100?> -- <?end if?> <?choose:?> <?when:COLUMN_NAME=’Y’?> --- <?end when?> <?end choose?> Thanks
-
Display Visual Analyzer inside BI Dashboard
Summary Display Visual Analyzer inside BI Dashboard Content Hi, Just getting familiar with the BICS interface before we upgrade from 11g and was wondering if it's possible to place a Visual Analyzer object onto a BI dashboard like you can with any Answers object? Seems bizarre to have these nice dynamic visualisations…
-
Unique field name values problem
Summary Unique field name values problem Content We use PT 8.55, in dutch. In our queries we use unique fieldname values. example: A.EMPLID -> unique fieldname "Employee Number" In the generated datasource we see the xml tag: "Employee Number" In the RTF we also see "Employee Number" als one of the input fields to pick…
-
Essbase connections (most of my DB connects but one wont, and no error log)
Summary Essbase connections (most of my DB connects but one wont, and no error log) Content hi I am connecting on prem desktop ODV to on prem Essbase 11.1.2.1 and 11.1.2.4. Most connections to my cubes are working fine, but one particular database that I have on both environments it seems to connect but then it gives an…
-
jar file extraction error
Hi Gurus, I am getting error with jar file extraction while installing Weblogic server 12c. Below the error. Please help to resolve the issue. Appreciate your help. Regards, Suresh.
-
R in OBIee - unused argument (isORE)
I've installed R (non-enterprise) on our OBIee 12c (12.2.1.2.0) development environment, with the functon packages and believe I've configured it as per the guide - 17 Configuring and Managing Analyses and Dashboards but when I try and use the functions I'm getting (forecast example, but same for others): Query Failed:…
-
Problem migrating from OBI 11g to OBI 12c
Hi, i'm trying to from OBIEE 11.1.1.7.150120 to OBIEE 12.2.1.2.0 and i've a problem while exporting OBI 11g environment (see logs). The 11g repository folder is E:\OBIEE\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository The execution doesn't return errors, but the export…
-
OBIEE Advance Analytic
Dears; I have a problem in using OBIEE advanced analytics, when I'm using one of the advanced analytics functions in OBIEE like Forecast, REG..., I get the below error : Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.…
-
OBIEE 12c stopped writing audit to IAU_COMMON
Hello, OBIEE 12c stopped writing audit to IAU_COMMON but continues to write audit to bus-stop file. Does anybody know solution? Thanks.
-
New graph option
is it possible to create a custom graph using a JavaScript and add it under the graph option under the analysis view options in obiee 12c??
-
How to create OBIEE What-Analysis?
Dear genius, I got a new task to create what if analysis in OBIEE, but I have no idea what that is and how to create it. Is anyone familiar with it? Could you give me a sample or guide about how to create the what-if analysis(predictive analysis)? Many thanks, Michael
-
IS IT OK TO CREATE METRICS IN BMM LAYER USING FOREIGN KEY
Hi Experts, I have a question on using foreign key to create metric in OBIEE. I have never seen metrics created on Key's/WID's in any of my previous implementations, even in BI Apps. Assume we have below fact and dimension. DW_SALES_F DW_SALES_ORDER_D ORDER_DT_KEY (foreign Key) SALES_ORDER_KEY (Primary Key) SALES_ORDER_KEY…
-
[Error] View Display Error in obiee 12c
Hi all, I'm having trouble creating dashboard in my obiee 12c version 12.2.1.2.0. Reports that you exceeded the configured maximum number of rows and columns. Att. Cláudio Torres Arbe
-
Is possible to set a variable in the query used in the dynamic repository variable init block data s
Hello OBIEE Community, I have this specific question, Is possible to set a variable in the query used in the dynamic repository variable init block data source with a value coming from Analytics? I have the following query to be used in a repository variable init block data source SELECT CONVERSION_RATE FROM GL_DAILY_RATES…
-
How to navigate to another report by clicking value?
Hi Experts， Customers want to click the value of columns in report created by BIEE to navigate new reports in another system, so I want to know how to pass the parameter for this value to another system by the following link (The values '1400007' is dynamical for clicking):http://mstg/Store/1400007 I try to use this…
-
List of dashboards and analyses
Hi all. Is it somehow possible to make (via Catalog Manager or any other ways) a list of all existing dashboards WITH analyses which are displayed on it? In Catalog Manager I only find an option to make a report with dashboards OR with analyses and their paths/folders/etc, but not with that two subjects together.
-
Page breaks and Repeatitive headers in BIP ETEXT Template
Hi All, Can any one help me to get page breaks and repeatitive headers in notepad after some 60 to 70 lines in ETEXT template using BI publisher tool? Need to provide solution to client.
-
Customizable columns in Pivot view
I have a requirement to show a report in a pivot view where the 'Quarter Period' (Q1,Q2,Q3,Q4) would be on the columns to show 3 or more measures (C1,C2,C3,C4) under each 'Quarter Period', for the 4previous quarter periods which is perfectly fine. Now the challenge is, as per the requirement, there should be additional 2…
-
OBIEE Problem
Hello, We have a big problem on obiee 11.1.1.7.140114 (Build 140126.2205.JANRECUT 64-bit) for three days. Suddenly, obiee analytics page does not respond only returning on browser. When I check opmn status, all are ALIVE status. Then, try to login enterprise manager, login page comes but when I click login button it does…
-
Large image in pdf output
Summary Large image in pdf output Content Hi, I have a scenario where my horizontal bar chart is very large and it doesnt fit inside a single page (PDF). I am using fo:instream-foreign-object for placing the chart. Could anyone please let me know if I can show this single image across two pages in PDF? Or can i scale the…
-
Fact table with dimension attributes
Hi, Not unusually I have a fact table that is not 'purely' fact, i.e. as well as keys and measures it also has attributes. Not liking attributes in fact folders I created a separate logical dimension table and put the offending fields in there. Both fact and dimension both use the same physical alias source. As I had…
-
Advanced SQL filter - passing all column values to presentation variable
Hi Everyone, Hoping all is well and hoping you find a quick min to respond to my question below. I have a below advanced filter where I am trying to have all column values as a default and/or when I run this report from a dashboard, the below filter on my report is not reading all column values from the dashboard prompt…
-
Direct landing page to dashboard?
Hi Is there a way to have a direct URL that can probably be bookmarked instead of logging into the OBIEE portal and navigating to the dashboard/ reports? We don't want users to do multiple clicks to land to that page. Any other alternatives? Thank you! P.S. We are new to OBIEE!
