2018-04-27 20:27
Blog Directory > Software Blogs > Programming Blogs > The Big Data - Business Intelligence by Sandeep Venu programming Blog >
The Big Data - Business Intelligence By Sandeep Venu Blog
obieelive.blogspot.com
Tags:
table
tocharaddmonthssysdate
informatica mdmhow
interface
prompt
sequence
google
slowly changing dimension
google map
monyy
Oracle Business Intelligence Blog by Sandeep Venu.
Certified implementation specialist with Oralce and a passionate blogger.
![Business Days In Current Month [Excluding Sat Sun]](https://cdn.blogarama.com/images/posts_thumbs_site_id/2509/250903-854818480.w320.jpg "Business Days In Current Month [Excluding Sat Sun]")
2018-01-23 14:09
You can use the following SQL to get the number of working days (not including sat and sun) of the current monthSELECT COUNT(TRUNC(SYSDATE,'MM') +(LEVEL-1)) AS BUSINESS_DAYS_IN_MTFROM DUALWH… Read More
2018-01-14 16:55
Hi All,Wanted to share the steps that you can do to create a dynamic heat map to mark Geo coordinates on google map. The heat map colors can be configured to be dynamic.This Example shown be… Read More
2017-07-20 15:45
For the OBIEE prompts to be used for BIP reports and to pass (All Column Values) and also multi select you can use the following SQL in the datamodelIn this, you can lease the prompts defaul… Read More
2017-03-06 18:59
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_PeriodFROM dualCONNECT BY LEVEL order by (TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'YYYYMM')) desc Read More
![ODI- Slowly Changing Dimension [SCD TYPE 2]](https://cdn.blogarama.com/images/posts_thumbs_site_id/2509/250903-2068073154.w320.jpg "ODI- Slowly Changing Dimension [SCD TYPE 2]")
2016-10-07 21:18
The below steps shows how SCD 2 is configured in ODI 11gPre requisites :ODI installed and configured with Topology for source and target is created.If not please check the steps to create th… Read More
2016-10-07 21:17
Hi ,For using Native Sequence generation in ODI interface, you can follow the below steps.CREATE TARGET TABLECREATE TABLE "TARGET"."SEQUENCE_TRIAL" ( "FAMILY_ID" NUMBER, "EMP_NAM… Read More
2016-10-07 21:17
Hi,
It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created and used with ODI 11g
In this example we will be co… Read More
2016-08-12 21:17
Tokenization process in Informatica MDM?How to create a basic Mapping in Informatica MDM?How to Unmerge records in Informatica MDM? Read More
2016-05-09 16:24
2016-05-09 16:23
Hi All, I read an article in the Oracle Blogs about implementing the early arriving facts or late dimensions and this is a re creation of that in my local server.This is the idea.In certain… Read More
2016-05-08 06:18
Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integration interfaces, thanks to CDC, Oracle Data Integra… Read More
2016-05-08 06:15
Early Arriving FactAn early arriving fact takes place when the activity measurement arrives at the data warehouse without its full context. In other words, the statuses of the dime… Read More
2016-05-08 05:57
2016-04-04 18:39
Hi,It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created and used with ODI 11gIn this example we will be conve… Read More
2016-03-30 19:09
Hi ,For using Native Sequence generation in ODI interface, you can follow the below steps.CREATE TARGET TABLECREATE TABLE "TARGET"."SEQUENCE_TRIAL" ( "FAMILY_ID" NUMBER, "EMP_NAM… Read More
2016-03-30 17:17
The below steps shows how SCD 2 is configured in ODI 11gPre requisites :ODI installed and configured with Topology for source and target is created.If not please check the steps to create th… Read More
2016-03-11 14:22
2016-02-05 22:51
To resolve this error:Set the below parameter in session level connected as SYS as SYSDBA: ALTER SESSION SET "_simple_view_merging"=TRUE scope=bothand execute the SQLThanks,Sandeep Read More
2015-10-07 14:28
During the development scenario, you might need to restrict access to the home link for the users. By disabling the privileges to access the home link will cause login issues and the users w… Read More
2015-10-06 14:28
Amazon Web Services set to debut new business intelligence tool, code-named ‘Space NeedleAmazon is all set to take a bite at the huge business intelligence industry with the relea… Read More
2015-10-01 13:32
RESOLUTION:Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in ‘Active’ state.Use the command prompt to verify the opmn status… Read More
2015-09-30 19:47
If you need to change the port of any obiee component then the steps are as belowNavigate to EM and expand the Weblogic domain folder > Bi foundation_domin > b_serverRight click on bi_… Read More
2015-09-10 15:25
For custom links, you can specify various attributes, including the followingThe text for the link (either a static string or a message name to use for localization).A URL to access.Whether… Read More
2015-09-04 19:54
Following are the steps to create a new OBIEE instance on an existing obiee instance . This new instance will behave completely independently environment and will be having an enterprise man… Read More
2015-07-09 16:55
Hi Everyone,The sample app 506 for OBIEE 11.1.1.9.0 is available for download and the detailed features of the package is available herehttp://www.oracle.com/technetwork/topics/virtualizatio… Read More
2015-06-30 15:54
Microsoft announced today that it will be launching Windows 10 on July 29th, encouraging Windows 7 and 8.1 users to reserve their free upgrade with a notification in their task bar. How… Read More
2015-06-19 18:52
2015-06-01 19:56
Microsoft used JetStream and Octane 2.0 benchmarks to show that Edge is faster than Internet Explorer, Google Chrome, and Mozilla Firefox. Interestingly, both JetStream and Octane… Read More
2015-05-28 12:58
Salesforce + Google + Cloudera + Hortonwork + New Relic + Informatica + Trifacta = BIG DATA analyticsThe news is that the six companies mentioned above have joi… Read More
2015-05-27 15:36
Download hereThese are the some of the new features available with OBIEE 11.1.1.9.0. (Doc ID 2010034.1)Answers and DashboardsScorecard and Strategy ManagementThis release provides the abilit… Read More
2015-05-08 13:21
You can change the default JVM heap size for the Administration Server and Managed Servers by setting the USER_MEM_ARGS parameter in the startup script for Oracle WebLogic Server. The foll… Read More
2015-05-06 15:35
Google has introduced a service for storing large amounts of data online, potentially enabling organizations to execute big data analysis as a cloud service.The offering, called Google… Read More
2015-03-11 01:25
Oracle DatabaseOBIEE ServerOBIEE RPDOBIEE MapsWeblogicErrorsUpgradeCustomizePatchHow to convert the existing 11.1.1.6.9 repository to 11.1.1.7.140415 without having to upgrade the old enviro… Read More
2015-03-06 22:06
Mobile App Designer InterfaceDrag and drop columns from the data source to the workspace to build the elements of your application.add tables, charts, maps, and so on, from the component add… Read More
2015-03-06 22:05
Step 1- Starting the Oracle BI Mobile App DesignerRequiredOracle BI EE 11.1.1.7.x. with patch # 18794832The default Sample App Lite repository should be available.The default URL is htt… Read More
2015-03-06 22:04
How to Add Pages to Your App Click New Page on the left, select New Page > 3 Cells.A second page is added to the app. Select the first cell.Click the add component ico… Read More
2015-03-06 22:04
How to Preview Your AppClick Preview to open a web preview of your app. Note, you can preview in a new Window too preview opens with the last page you were working, in this ca… Read More
2015-03-06 13:29
Scenario The proxyuser table is set up as follows:ProxyUser TargetUser ProxylevelAdmin2 Cons1 restrictedAdmin1 Cons1 … Read More
2015-03-06 02:08
Change the table or pivot table property: data viewing to content paging.The table property : data viewing set to : Fixed headers with scrolling content as default value in 11… Read More
2015-03-06 02:05
The OBIEE scheduler has been configured in Enterprise Manger Fusion Middleware Control to connect to the BIPlatform schema.After upgrading OBIEE 11.1.1.5 to OBIEE 11.1.1.7.1 on a clust… Read More
2015-03-06 01:59
OBIEE 11g: Error: "[nQSError: 46029] Failed to load the DLL /u01/app/oracle/product/11.1/middleware/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewaydb2cli3564.so" after Upgrade to OBIEE 11… Read More
2015-03-06 01:58
While upgrading to OBIEE 11.1.1.7, the upgrade script needs to be run a second time in a row, the config.sh script does not go past the "Update BI Domain Step.This is caused because Whe… Read More
2015-03-06 01:32
A graph view with a measure using Average aggregation rule in Analytics 11.1.1.7.x version shows incorrect data.Normal aggregated data instead of average data is displayed.The issue is only… Read More
2006-06-07 11:16
This example demonstrates the possibility of accessing an image directly from the catalog without having to access it through a WLS deployment folder structureThe image is stored in the ca… Read More
2006-06-07 11:16
This can be useful for testing purposes to check syntax of SQL queries generated without really hitting the database.SET VARIABLE SKIP_PHYSICAL_QUERY_EXEC=1, DISABLE_CACHE_HIT=1, DISABLE_CAC… Read More
2006-06-07 11:16
Analyses often have sparse data that includes null rows and/or columns. By default, these null rows/columns are always suppressed. To allow designers to display this data, a Null Non… Read More
2006-06-07 11:16
OBIEE Queries cache hit or cache seeding can be simply disable by prefixing a clause setting a variable value in the logical SQL of the query. Logical SVP Prefix clauses can be added or ed… Read More
Subscribe to The Big Data - Business Intelligence By Sandeep Venu
Get updates delivered right to your inbox!