-
How to give left outer join with "LIKE operator" in obiee 11g RPD?
Hi, I am working on obiee 11g. When i am creating RPD, i have to give left outer join with LIKE Operator.. My tables are W_LD_REPAY_D,W_CONTRACT_STATIC_D For example,mappping is as follow LEFT JOIN : W_LD_REPAY_D.ID LIKE W_CONTRACT_STATIC_D.CONTRACT_CODE||'%' I dont know, How to give above join in RPD? Please help me,…
-
Oracle OBIEE report query
HI, I would like to know if there is a way to get the the physical SQL query for a given report. requirement: * the query maybe stored in a table in the database (metadata) and can be obtained by running an SQL statement. * the dashboard report may provide a query ID or SQL_ID or something related. * I need to be able to…
-
OBIEE Export to Excel issue - Leading space not getting exported to Excel/PDF
There is a Leading space in data (for Ex ' abc') and is displaying correctly in dashboard but when we export it to PDF/Excel, the leading space is trimmed Off. I want to preserve the Leading space as well while exporting. I am currently using OBIEE 11.1.1.7.151020. It looks like after the recent patch upgrade from…
-
Set pdqpriority for reports in OBIEE
Hi, Im using informix as the datasource for OBIEE 11g, I want obiee to set pdqpriority of informix database everyt ime a report is run to maximize the cpu usage. Is that allowed in OBIEE database direct access? Please help. Thank you.
-
when we are not getting right data or no data what are the steps we have to do
Thanks In Advance
-
Catalog Manger to find all reports on a dashboard
I am trying to find all the reports present on a Dashboard + all the reports referenced by the reports on this dashboard (either in form of action links present on the dashboard page or in form of reports present as action links under "Column Properties" -> "Interaction" ) . But when I use Create Report option in catalog…
-
Math operations in result column of a UNION (combined analysis)
I need to know a % of UNION result, for that I added a column result to UNION operation. If i only select that it show me one column and it Works perfectly but when i try to make math operations the result is incorrect. Can i make math operations in result column of a UNION?
-
OBIEE Sample v506 BIApps Plug-in problem
hi, I've recently installed the obiee sample v506 virtual machine because i need to see the biapps plug-in in it however after deploy all services of the instance 2 (which contains the biapps plug in) i get the error Error Codes: OPR4ONWY:U9IM8TAC I2DL65P State: HY000. Code: 10058 which means i cant access to any data view…
-
Write Back Error :unable to read the Write Back Template
Hello I'm trying to create a report that perform Writeback (update field ). I built it step by step according to instructions. When I try to update in the report, I get the message: The system is unable to read the Write Back Template 'testwriteback'. Please contact your system administrator the "Write Back Template" saved…
-
Export functionality
I am a developer and use the Oracle BIEE for creating panels. Recently I came across the malfunction option "export" of a particular analysis. The option to export to an Excel file can not download all table record lines on display. I could only export the table using the option to " delimited format for tabulation ."…
-
Apply filter on hierarchical column with selection steps
Hi, i need to pick only certain rows from the hierarchical column EX: A is the parent in the hierarchical column B and C are children to A D and E are children to B F and G are children to C and so on My requirement is to pick rows A,D and F. So in selection steps I keep only A,D and F to display in the report.But the…
-
Installation Question (OBIEE 11.1.1.7 + OHS)
Hi all, Bit of an urgent one here. I've been planning an installation for a couple of months now which is said to go ahead this weekend. The plan is to move our OBIEE installation from a virtual machine to a physical box with far more grunt. Unfortunately, because they'll be running different OS's, cloning wasn't an option…
-
How to calculate month end dates from all months?
Hi, I am getting last day of current month. That formulae is TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) But, I want month end dates only from all months.i need formula for this. Please help me. Thanks & Regards,…
-
Hiding Report Header Section
Hi friends, I have the report with no column headings like below Is it possible to hide the empty column heading space row header @ the top of the report so that my report will look like below Thanks in advance. Regards, Saro
-
How to create Summary Table at top of the Dashboard
Hello I have Dashboard contain 10 analysis , each analysis contain row count at the end , But I want those analysis row count should show in one table (Summary) Thanks in Advance ........... Please help as much possible I want the count of those analysis in single table at to
-
Unicode Apps
Hii .. Any one has any case study on Unicode apps .. how client can benefit out of it... Thanks
-
OBIEE Upgrade from 11.1.1.7.131017 to 11.1.1.9.0
Hi all, We are trying to upgrade OBIEE from 11.1.1.7.131017 to OBIEE 11.1.1.9.0. During the upgrade as per Oracle doc we were successful in WLS upgrade from 10.3.5 to 10.3.6, software only installation of OBIEE 11.1.1.9.0, psu.sh execution to upgrade the MDS and BIPLATFORM schemas but while executing the config.sh the…
-
OBIEE 11.1.1.9 - Requirements for a shared mountpoint
Hi, OBIEE.....: 11.1.1.9 OS..........: AIX 7.1 Database: 12.1.0.2 We are planning to install OBIEE in a cluster of 2 nodes. I was reading the Oracle docs and didn't find any information about a shared location to be used by the nodes in the cluster. My simple question is: Is it necessary to have a shared filesystem…
-
Combining two types of recordsin obiee
I am new and still learning what can be done in obiee. I am trying to combine two types of records and eliminate ones that don't have full info. For example, 111, beginning time, 0100 111, ending time, 0500 222, beginning time, 0200 333, beginning time, 0300 333, ending time, 0500 Desired result is full info (beginning and…
-
Oracle Obiee web services list
Hi, in an Oracle dashboard, i would like to know how to update an existing Oracle Obiee web services list? let's say, I have a new webService and I want to add it to the list of webServices when the user tries to invoke a webService from an action. i tried to modify the ActionFrameWorkConfig.xml file but it seems I am not…
-
Evaluate_Aggr OBIEE Essbase datasource
Hi Experts, I am relatively new to OBIEE. I am trying to retrieve data in OBIEE analysis measure using the formula Evaluate_AGGR('/*%1*/([Actual],[61000_00],[FY14])' as DOUBLE ,"Measures"."Gen1,Measures" ) + Evaluate_AGGR('/*%1*/([Actual],[62000_00],[FY14])' as DOUBLE ,"Measures"."Gen1,Measures" ) It gives correct results…
-
OBIEE 11C Forecast R_EXECUTABLE_PATH
I have recently upgraded to test 11c from 10g. There are two areas of functions in 11c that I'm interested in test: (1) Timer Series Calculations and (2) Analytics. In readying the setup it appears that I need to setup R to used the advanced Analytics functionality. I interpretted this as the functions within the Analytics…
-
Previous row value (NOT MEASURE) in vertical fact architecture
Hi OBIEE experts, I've been looking for my answers for a while but no luck so far :/ . We have vertical fact architecture in organisation with 11.1.1.7 version. One of the requirements is to have current and previous (month or quarter) attribute in one line ( not measure ! ) So far my approach was : a) select data for…
-
Asset reports derivation
Hi all, We have to develop a Asset report for this there are some dervied columns like cash and cash on balances are present , these are based on some accounts in GL so where can we write the logic for these in BMM layer, each column we have to use the case when and derive the value or any other approach? Thanks in advance…
-
OBIEE 12c connects to Essbase
Dear experts, I'm trying to connect OBIEE 12c with Essbase from a different server. Importing metadata is working fine, I got physical layer until presentation layer. But when I tried to view member in Physical layer, i got error message "[NQODBC] [SQL_STATE:HY000] [nQSError: 10058] A general error has occurred". During…
-
Python Script to look the users that belong to a group in weblogic
Hi Does any one know Python Script to look for the users that belong to a particular group in weblogic
-
Show User GUID for all user
Hi, I have question, because I created scorecard and If i see the scorecard properties there is someone who is editing scorecard (CurrentEditedBy). This number is User GUID. Is it possible to view all User GUID for all users?
-
OBIEE 11.1.1.7 Integration with Workspace 11.1.2.4
Hi Experts, I have integrated OBIEE 11.1.1.7 with EPM workspace 11.1.2.4 and enabled SSO. Everything works but I don't see the OBIEE Home, Catalog, Favourites, Dashboards, New etc shortcuts when I log into workspace. Any option I am missing?
-
Subtotal on Group by
Hi friends, Im in OBIEE 11.1.1.7. I have a report with the following columns like below If u can see @ the above 419 is my employee no which has two records for one of the column as 26116.93 and 0.00 for self and child. i want to display another column seperately with a sum of total of 26116.93+0.00. As i need this another…
-
OBIEE Line-Bar Chart - Show data labels for specific measure
Hello, Is it possible to show the data labels for only one measure in a line-bar chart in OBIEE? We have a chart displaying three distinct measures and have a requirement in order to show the data labels only for the measure shown in black on the image below: Thanks. Regards, Jaime Machado
