<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>GerardNico.com (BI, OBIEE, OWB, DataWarehouse)</title>
	
	<link>http://gerardnico.com/weblog</link>
	<description>Business Intelligence, System Integration and Automation WebBlog</description>
	<pubDate>Sun, 14 Feb 2010 15:05:33 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.7.1</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/Gerardnicocom" /><feedburner:info uri="gerardnicocom" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>OBIEE - Dimension fragmentation design to add an automatic filter with the choice of a column</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/phm5nKcq4OE/</link>
		<comments>http://gerardnico.com/weblog/2010/02/13/obiee-dimension-fragmentation-design-to-add-an-automatic-filter-with-the-choice-of-a-column/#comments</comments>
		<pubDate>Sat, 13 Feb 2010 22:29:29 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=174</guid>
		<description><![CDATA[

In response to an original Idea of Venkat with this blog entry: Puzzlers – Puzzle 1


“How do we make BI EE to generate different filters for every column(within a dimension) chosen from Answers?”


The idea is when you add the column Channel desc to an answer the query must be automatically filtered.


You can also found a [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2010/02/13/obiee-dimension-fragmentation-design-to-add-an-automatic-filter-with-the-choice-of-a-column/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2010/02/13/obiee-dimension-fragmentation-design-to-add-an-automatic-filter-with-the-choice-of-a-column/</feedburner:origLink></item>
		<item>
		<title>Oracle Warehouse Builder 11g: Getting Started (Paperback) by Robert Griesemer</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/-U0TFFzUUAU/</link>
		<comments>http://gerardnico.com/weblog/2009/10/29/oracle-warehouse-builder-11g-getting-started-paperback-by-robert-griesemer/#comments</comments>
		<pubDate>Thu, 29 Oct 2009 10:17:49 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OWB]]></category>

		<category><![CDATA[Uncategorized]]></category>

		<category><![CDATA[book]]></category>

		<category><![CDATA[data integration tool]]></category>

		<category><![CDATA[datawarehouse]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=162</guid>
		<description><![CDATA[




Oracle Warehouse Builder 11g: Getting Started by Robert Griesemer - ISBN 1847195741


Packt Publishing offer me the chance to review this book and I want to thank them as the author Robert Griesemer because writing a book is never an easy task.


The book is a step by step tutorial offering to construct a complete datawarehouse environment [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/10/29/oracle-warehouse-builder-11g-getting-started-paperback-by-robert-griesemer/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/10/29/oracle-warehouse-builder-11g-getting-started-paperback-by-robert-griesemer/</feedburner:origLink></item>
		<item>
		<title>OBI Forum Live Second Edition</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/6QdFWHoyUVA/</link>
		<comments>http://gerardnico.com/weblog/2009/05/28/obi-forum-live-second-edition/#comments</comments>
		<pubDate>Thu, 28 May 2009 18:12:54 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<category><![CDATA[OBIEE]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=141</guid>
		<description><![CDATA[

I&#039;m going to present in the OBI Forum Live the next week on the 3th Wednesday of Juny 2009.


This second edition is really impressive and as I see that we will have parallel sessions, I&#039;m already very disappointed because I couldn&#039;t assist to all presentations :



 Multi-Language Dashboards,  John Minkjan


 Oracle BI EE en [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/05/28/obi-forum-live-second-edition/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/05/28/obi-forum-live-second-edition/</feedburner:origLink></item>
		<item>
		<title>Densification with OBIEE logical Sql (Sparse to dense data)</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/yj_kzAFNQt0/</link>
		<comments>http://gerardnico.com/weblog/2009/05/12/densification-with-obiee-logical-sql-spare-to-dense-data/#comments</comments>
		<pubDate>Tue, 12 May 2009 08:33:58 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[dense]]></category>

		<category><![CDATA[densification]]></category>

		<category><![CDATA[sparse]]></category>

		<category><![CDATA[sql]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=128</guid>
		<description><![CDATA[


You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them.


And it&#039;s also the most problem that you have when you work with time series calculations as the lag/lead function, is that the data are not dense.


This article show [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/05/12/densification-with-obiee-logical-sql-spare-to-dense-data/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/05/12/densification-with-obiee-logical-sql-spare-to-dense-data/</feedburner:origLink></item>
		<item>
		<title>Obiee - How to configure the Mail server of Oracle BI Scheduler/Delivers</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/mZsJqCe3ZkY/</link>
		<comments>http://gerardnico.com/weblog/2009/04/26/obiee-how-to-configure-the-mail-server-of-oracle-bi-schedulerdelivers/#comments</comments>
		<pubDate>Sun, 26 Apr 2009 13:47:46 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[bi_scheduler]]></category>

		<category><![CDATA[smtp]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=124</guid>
		<description><![CDATA[


This article talk about the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as :



 the sender address


 the smtp server


 the smtp port


&#60;span id=“more-124”&#62;&#60;/span&#62;

To be able to save an Ibot, you must have performed the initial configuration.


If you have [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/04/26/obiee-how-to-configure-the-mail-server-of-oracle-bi-schedulerdelivers/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/04/26/obiee-how-to-configure-the-mail-server-of-oracle-bi-schedulerdelivers/</feedburner:origLink></item>
		<item>
		<title>OBIEE and Apex Integration</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/9_jgpQFo9tU/</link>
		<comments>http://gerardnico.com/weblog/2009/04/25/obiee-and-apex-integration/#comments</comments>
		<pubDate>Sat, 25 Apr 2009 12:55:40 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[apex]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=114</guid>
		<description><![CDATA[

You may have sometime to change some data in your application.


Apex is a great tool that allow you to develop and deploy rapidly a web based application.


Here for our example, we must access to a vendor Apex form to change some values on it.


Our goal is to have the report below in OBIEE with one [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/04/25/obiee-and-apex-integration/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/04/25/obiee-and-apex-integration/</feedburner:origLink></item>
		<item>
		<title>Obiee - Period to period comparison with the analytical function Lag/Lead</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/UtIcnnh_gCg/</link>
		<comments>http://gerardnico.com/weblog/2009/04/17/obiee-period-to-period-comparison-with-the-analytical-function-laglead/#comments</comments>
		<pubDate>Fri, 17 Apr 2009 21:57:32 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[ago]]></category>

		<category><![CDATA[analytic function]]></category>

		<category><![CDATA[time function]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=109</guid>
		<description><![CDATA[


During this thread on the Obiee forum, Goran point out a solution for a period to period comparison with the analytical function lag. It was time for me to drill down in this analytical function and to compare it with the obiee time function : ago.


lag and lead are analytical functions that can be used [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/04/17/obiee-period-to-period-comparison-with-the-analytical-function-laglead/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/04/17/obiee-period-to-period-comparison-with-the-analytical-function-laglead/</feedburner:origLink></item>
		<item>
		<title>Obiee - A special subject area to handle the dashboard parameters prompts</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/mDMczwOJN0k/</link>
		<comments>http://gerardnico.com/weblog/2009/04/17/a-special-subject-area-to-handle-the-dashboard-parameters-prompts/#comments</comments>
		<pubDate>Fri, 17 Apr 2009 21:40:07 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[dashboard prompt]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=104</guid>
		<description><![CDATA[

All the prompts in OBIEE are column based prompt. You can&#039;t create a prompt if you don&#039;t select a column. And as it&#039;s the only way to set up a variable for a formula, it&#039;s impossible to bypass this constraint.


In our case, we don&#039;t care about the value in the dimension column as we want [...]]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/04/17/a-special-subject-area-to-handle-the-dashboard-parameters-prompts/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/04/17/a-special-subject-area-to-handle-the-dashboard-parameters-prompts/</feedburner:origLink></item>
		<item>
		<title>Obiee - How to suppress detail rows of a master group in a pivot view ?</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/wJRz-c8wgHg/</link>
		<comments>http://gerardnico.com/weblog/2009/04/10/obiee-how-to-suppress-detail-rows-of-a-master-group-in-a-pivot-view/#comments</comments>
		<pubDate>Fri, 10 Apr 2009 10:47:05 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[css]]></category>

		<category><![CDATA[pivot]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=83</guid>
		<description><![CDATA[You have detail rows of a group in a pivot table that you want suppress,
We have two solutions :
  - if you don't need a total by "promo Category" (by post or by internet), you can create a new dimension with a formula
  - if you want a total by "promo Category", we must perform a cross conditional formatting.  ]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/04/10/obiee-how-to-suppress-detail-rows-of-a-master-group-in-a-pivot-view/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/04/10/obiee-how-to-suppress-detail-rows-of-a-master-group-in-a-pivot-view/</feedburner:origLink></item>
		<item>
		<title>Obiee - How to mix string and number data type in one column and get a sum ?</title>
		<link>http://feedproxy.google.com/~r/Gerardnicocom/~3/lmwucW6GWSQ/</link>
		<comments>http://gerardnico.com/weblog/2009/04/09/how-to-mix-string-and-number-data-type-in-one-column-and-get-a-sum/#comments</comments>
		<pubDate>Thu, 09 Apr 2009 10:57:18 +0000</pubDate>
		<dc:creator>gerardnico</dc:creator>
		
		<category><![CDATA[OBIEE]]></category>

		<category><![CDATA[css]]></category>

		<guid isPermaLink="false">http://gerardnico.com/weblog/?p=77</guid>
		<description><![CDATA[Sometimes, you want to mix number and string data type in one column because you want to send a conditional message :

For instance, :
  * if value > 1000, write "To Big" else value
  * if value is null, write "No Data" else value

But If you write a function, on this way, you get a error message. Here is how to do to avoid it.
]]></description>
		<wfw:commentRss>http://gerardnico.com/weblog/2009/04/09/how-to-mix-string-and-number-data-type-in-one-column-and-get-a-sum/feed/</wfw:commentRss>
		<feedburner:origLink>http://gerardnico.com/weblog/2009/04/09/how-to-mix-string-and-number-data-type-in-one-column-and-get-a-sum/</feedburner:origLink></item>
	</channel>
</rss><!-- Dynamic page generated in 3.583 seconds. --><!-- Cached page generated by WP-Super-Cache on 2010-03-15 19:42:06 -->
