<?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:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>David Lai's Business Intelligence Blog</title>
	
	<link>http://davidlai101.com/blog</link>
	<description>Just another WordPress weblog</description>
	<lastBuildDate>Sat, 20 Feb 2010 22:05:50 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9.2</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/DavidLaisBusinessIntelligenceBlog" /><feedburner:info uri="davidlaisbusinessintelligenceblog" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><feedburner:emailServiceId>DavidLaisBusinessIntelligenceBlog</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>Understanding Business Objects Inheritance</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/sNnAcEIkXnE/</link>
		<comments>http://davidlai101.com/blog/2010/02/20/understanding-business-objects-inheritance/#comments</comments>
		<pubDate>Sat, 20 Feb 2010 22:02:26 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Best Practices]]></category>
		<category><![CDATA[Business Objects]]></category>
		<category><![CDATA[best practices]]></category>
		<category><![CDATA[content management]]></category>
		<category><![CDATA[Inheritance]]></category>
		<category><![CDATA[User Access]]></category>
		<category><![CDATA[User Management]]></category>

		<guid isPermaLink="false">http://davidlai101.com/blog/?p=233</guid>
		<description><![CDATA[When setting up user and group rules, it is important to understand inheritance and how inheritance works.  Otherwise you may run into unexpected access rights for your groups and users.
Global to object level hierarchy
By default, groups and users will inherit rights from the highest level.
The highest level starts at the Global Settings level.  The second [...]]]></description>
			<content:encoded><![CDATA[<p>When setting up user and group rules, it is important to understand inheritance and how inheritance works.  Otherwise you may run into unexpected access rights for your groups and users.</p>
<h2><span style="color: #00ccff;">Global to object level hierarchy</span></h2>
<p>By default, groups and users will inherit rights from the highest level.</p>
<p>The highest level starts at the Global Settings level.  The second level is the folder level; and finally the lowest level is at the object level.  If we set rights at the current level itself, then those rights have precedence over inheritance <span style="color: #ff0000;"><strong><em>(except if rights have explicitly been denied)</em></strong></span></p>
<p>Here are a few examples of setting up a group at multiple levels</p>
<p><img class="aligncenter size-full wp-image-235" title="object-security" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/object-security1.jpg" alt="" width="635" height="319" /><br />
<span id="more-233"></span></p>
<h2><span style="color: #00ccff;">Group and User security Overlap</span></h2>
<p>Use the following formulas as a guide to understand what happens when inheritance from multiple groups overlap</p>
<ul>
<li>Grant + Deny + Not Specified = Deny</li>
<li>Grant + Not Specified = Grant</li>
<li>Grant + Deny = Deny</li>
<li>Not Specified = Denied</li>
</ul>
<p>For Predefined access levels, the access level with more access will take precedence.</p>
<p><strong>For example:</strong></p>
<p>If user <em>“James”</em> is part of Group <em>“Sales”</em> and <em>“Marketing”</em>.</p>
<p>If <em>“Sales”</em> has <em>“View”</em> access on the Marketing Folder and <em>“Marketing”</em> has <em>“Schedule”</em> access on the Marketing folder.  <em>“James”</em> will have “Schedule” access on the Marketing folder.</p>
<h4>User rights take precedence over inherited rights</h4>
<p>User rights will always take precedence over inherited rights.</p>
<p><strong>For example:</strong></p>
<p>User <em>“James”</em> is part of the <em>“Marketing”</em> and has <em>“Schedule”</em> access on the Marketing folder.  However we set <em>“James”</em> with <em>“View”</em> access on the Marketing folder.  View access will then take precedence.</p>
<p>The only time an inherited right takes precedence is if an inherited right explicitly denies access.  To override an inherited deny, you must uncheck the box that inherits rights.</p>
<p><img class="aligncenter size-full wp-image-236" title="advanced-rights" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/advanced-rights.jpg" alt="" width="547" height="232" /></p>
<h2><span style="color: #00ccff;">Recommendations</span></h2>
<ul>
<li>Assign security at the folder level to groups whenever possible.  Avoid setting rights for specific users on specific report objects.  This will reduce the complexity of your system security model.</li>
<li>Use predefined access levels whenever possible.</li>
<li>Grant the “Everyone” group No Access at the global level and then grant specific rights to the appropriate groups to prevent any loopholes.</li>
<li>When setting rights, make sure to include the appropriate Universes and Business Views as well since access may be denied if they are not included.</li>
</ul>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/sNnAcEIkXnE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2010/02/20/understanding-business-objects-inheritance/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2010/02/20/understanding-business-objects-inheritance/</feedburner:origLink></item>
		<item>
		<title>Xcelsius 2008 advanced workshop</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/_d_jY5IPg0s/</link>
		<comments>http://davidlai101.com/blog/2010/02/19/225/#comments</comments>
		<pubDate>Fri, 19 Feb 2010 06:23:13 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Xcelsius]]></category>
		<category><![CDATA[workshop]]></category>

		<guid isPermaLink="false">http://davidlai101.com/blog/?p=225</guid>
		<description><![CDATA[
Join the Xcelsius gurus, Mike Alexander (Author, Crystal Xcelsius For Dummies/ Founder, Data Pig Technologies) and Mico Yuk (Founder, Everything Xcelsius / Xcelsius Gurus Network) for a 2-day Xcelsius 2008 advanced workshop this upcoming March 2010 in Dallas, TX!  The workshop which contains a wide array of advanced Xcelsius tips and techniques sold out [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.regonline.com/builder/site/Default.aspx?eventid=789603"><img class="alignnone" style="margin-left: 110px; margin-right: 110px;" title="Xcelsius Training" src="http://everythingxcelsius.com/wp-content/themes/EverythingXcelsius/images/xcelsiustraining.gif" alt="" width="365" height="140" /></a><br />
Join the Xcelsius gurus, Mike Alexander (Author, <a href="http://www.datapigtechnologies.com/">Crystal Xcelsius For Dummies</a>/ Founder, Data Pig Technologies) and Mico Yuk (Founder, <a href="http://www.everythingxcelsius.com/">Everything Xcelsius</a> / Xcelsius Gurus Network) for a 2-day <a href="http://www.regonline.com/builder/site/default.aspx?EventID=789603">Xcelsius 2008 advanced workshop</a> this upcoming March 2010 in Dallas, TX!  The workshop which contains a wide array of advanced Xcelsius tips and techniques sold out when it was first held in March of 2009 and here is why….</p>
<p>• Learn how to enhance your data models with advanced Excel functions<br />
• Learn powerful dashboard design and charting techniques<br />
• Learn tricks that will help to optimize the performance of your Xcelsius dashboards<br />
• Gain a solid understanding of XML and XML connectivity in Xcelsius<br />
• Create server-based logins for your Xcelsius dashboards<br />
• Learn how to pass parameters from one Xcelsius dashboard to another<br />
• Learn how create detailed drill-throughs in Xcelsius  using encoded URLs<br />
• Learn how to use your Xcelsius dashboards to write back to your server</p>
<p>Much more…</p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/_d_jY5IPg0s" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2010/02/19/225/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2010/02/19/225/</feedburner:origLink></item>
		<item>
		<title>Understanding Business Objects Access Levels</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/5iMYpFWRChE/</link>
		<comments>http://davidlai101.com/blog/2010/02/19/understanding-business-objects-access-levels/#comments</comments>
		<pubDate>Fri, 19 Feb 2010 05:44:03 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Best Practices]]></category>
		<category><![CDATA[Business Objects]]></category>
		<category><![CDATA[Access Levels]]></category>
		<category><![CDATA[best practices]]></category>
		<category><![CDATA[User Access]]></category>
		<category><![CDATA[User Management]]></category>

		<guid isPermaLink="false">http://davidlai101.com/blog/?p=209</guid>
		<description><![CDATA[Understanding the Business Objects security model will enable you to map out a content management strategy for your organization.  Visit my previous post at http://davidlai101.com/blog/2008/11/06/content-management-planning-in-business/ after understanding user access levels and inheritance to setup your content.  In this article we&#8217;ll go through the Business Objects Enterprise Access Levels.
There are 2 ways of assigning access [...]]]></description>
			<content:encoded><![CDATA[<p>Understanding the Business Objects security model will enable you to map out a content management strategy for your organization.  Visit my previous post at <a href="http://davidlai101.com/blog/2008/11/06/content-management-planning-in-business/">http://davidlai101.com/blog/2008/11/06/content-management-planning-in-business/</a> after understanding user access levels and inheritance to setup your content.  In this article we&#8217;ll go through the Business Objects Enterprise Access Levels.</p>
<p>There are 2 ways of assigning access in Business Objects Enterprise</p>
<p><strong><span style="text-decoration: underline;">Predefined Access Levels</span></strong></p>
<p>Predefined access levels are a collection of individual rights that have been set up in the Business Objects Enterprise system to provide common user access requirements.</p>
<p><strong><span style="text-decoration: underline;">Advanced rights</span></strong></p>
<p>By going into the advanced rights, you may totally customize the type of access a user has on an object.</p>
<p><img class="alignleft size-full wp-image-210" title="access-rights" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/access-rights.jpg" alt="" width="660" height="211" /><br />
<span id="more-209"></span><br />
It is simplest to use predefined access levels, as we don’t have to manually configure every single right.</p>
<p><strong><span style="text-decoration: underline;">Below is a table of Predefined access levels</span></strong></p>
<table border="1" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="319" valign="top">Access Level</td>
<td width="319" valign="top">Rights</td>
</tr>
<tr>
<td width="319" valign="top">No Access</td>
<td width="319" valign="top">The no access level may be misleading.   The no access level does not explicitly   deny access, but rather, sets all permissions to “Not Specified.”  This can be overridden through inheritance.</td>
</tr>
<tr>
<td width="319" valign="top">View</td>
<td width="319" valign="top">When set at the folder level, the user can view the folder, the   objects contained in the folder, and all generated instances of each object.</p>
<p>At object level, the user can view the object, history of the object,   and all generated instances of the object.</p>
<p>The user cannot schedule or refresh the report, however by default;   the user can edit the report and save to a personal folder to refresh   there.  You can deny users from copying   the object by going to advanced and denying “Copy Objects to another folder”</td>
</tr>
<tr>
<td width="319" valign="top">Schedule</td>
<td width="319" valign="top">A user can generate instances by scheduling the object to run against   a specified data source once or on a recurring basis.  The user has full access to the scheduled   instances that they own.  They can also   schedule to different formats and destinations, set parameters, pick servers   to process jobs, add contents to the folder, and copy the object or folder.</td>
</tr>
<tr>
<td width="319" valign="top">View On Demand</td>
<td width="319" valign="top">A user can refresh a report in real time.  Note that if a report is a WEBI document,   the user will also need View On Demand access to the universe and universe   connection to perform the refresh.</td>
</tr>
<tr>
<td width="319" valign="top">Full Control</td>
<td width="319" valign="top">Allows users to modify all of the object’s properties.  This is the only access level that allows   users to delete objects.</td>
</tr>
</tbody>
</table>
<h1></h1>
<h1><span style="color: #3366ff;"><strong>Security Hierarchy</strong></span></h1>
<p>The security levels flow in the following manner:</p>
<ul>
<li>Global security</li>
<li>Folder-level security</li>
<li>Object-level security</li>
</ul>
<h2><strong>Global Security</strong></h2>
<p>The default security set for the entire system.   For example when a new folder is added, its default rights come from the global level.</p>
<p>If there are any access levels that are common for the entire system, you should set them at the global level.</p>
<p><img class="alignleft size-full wp-image-212" title="global-settings" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/global-settings.jpg" alt="" width="730" height="312" /></p>
<p>Global level rights can be set at the settings management area of the Central Management Console</p>
<h2><strong>Folder-level security</strong></h2>
<p>Folder level security allows you to set access-level rights for a folder and objects contained within that folder.  Subfolders will inherit the security of their parent folders.</p>
<p><img class="alignleft size-full wp-image-213" title="folder-settings" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/folder-settings.jpg" alt="" width="732" height="280" /></p>
<p>Folder level security can be set by going to the “Folders” page of the CMC, then selecting a folder, and then clicking on the Rights tab.</p>
<h2><strong>Object Level security</strong></h2>
<p>Object level security is the access-level rights set at the object level.</p>
<h1></h1>
<h1><span style="color: #3366ff;"><strong>Folders and Categories</strong></span></h1>
<p>It is important to understand the differences between folders and categories.  Both provide a way of organizing documents and BI content.  <em>Folders provide the physical storage location of a file as well as navigation to content.  Categories provide navigation only</em>.  Folders are required whereas categories are optional.  Thus when using a combination of both, it is recommended that categories are used for navigation only and permissions be set at the folder level.</p>
<p>When you create a new folder, two sets of permissions are automatically assigned:</p>
<ul>
<li>Administrators are given the access level Full Control</li>
<li>Everyone is given the access level Schedule</li>
</ul>
<p><img class="alignleft size-full wp-image-214" title="folder-default" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/folder-default.jpg" alt="" width="817" height="329" /></p>
<p>Since the “Everyone” group is assigned the default access level of Schedule when a folder is first created, all users are able to view, open and schedule any reports saved in the new folder.  For many companies, this type of access level may not be acceptable, so the best practice is to make sure “No Access” is set for the “Everyone” group when creating a new folder.  If you want to give more permission, you can tweak it later on.</p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/5iMYpFWRChE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2010/02/19/understanding-business-objects-access-levels/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2010/02/19/understanding-business-objects-access-levels/</feedburner:origLink></item>
		<item>
		<title>Fusion Charts Wrapper Online Guide</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/ErVfvIjv9MM/</link>
		<comments>http://davidlai101.com/blog/2010/02/03/fusion-charts-wrapper-online-guide/#comments</comments>
		<pubDate>Wed, 03 Feb 2010 07:14:37 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Fusion Charts]]></category>
		<category><![CDATA[Java Wrapper]]></category>
		<category><![CDATA[Online Guide]]></category>

		<guid isPermaLink="false">http://davidlai101.com/blog/?p=186</guid>
		<description><![CDATA[Here&#8217;s the online guide to the Fusion Charts Wrapper found at http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/
If you just need the JavaDocs, please go to http://davidlai101.com/fusioncharts-javadoc/
Steps to build a Fusion Chart in Java
Please ensure that you have example.jsp and example_alternative.jsp open in order to follow the steps below to build a fusion graph.
If you haven&#8217;t downloaded the full project file [...]]]></description>
			<content:encoded><![CDATA[<p>Here&#8217;s the online guide to the Fusion Charts Wrapper found at <a href="http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/">http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/</a></p>
<p>If you just need the <em>JavaDocs</em>, please go to <a href="http://davidlai101.com/fusioncharts-javadoc/">http://davidlai101.com/fusioncharts-javadoc/</a></p>
<h3><span style="color: #3366ff;"><strong>Steps to build a Fusion Chart in Java</strong></span></h3>
<p>Please ensure that you have example.jsp and example_alternative.jsp open in order to follow the steps below to build a fusion graph.</p>
<p>If you haven&#8217;t downloaded the full project file please download it <a href="http://www.davidlai101.com/blog/media/blogs/bobj/fusioncharts/1.0/fusioncharts-fullsource.zip">here</a></p>
<h3><span style="color: #3366ff;"><strong>Create FusionGraph</strong></span></h3>
<p>First you will want to create a FusionGraph object and set its properties<br />
To create a FusionGraph object you will need to define a Graph Id, Chart Type which is an enum from ChartType and the size of items in each of it’s series.  Let’s start with a simple pie graph example that has 5 slices.<br />
<span id="more-186"></span></p>
<blockquote><p>FusionGraph pieGraph = new FusionGraph(“pieGraph”,ChartType.PIE3D,5,request);</p></blockquote>
<p>Note that the request parameter is required so that we can send the FusionGraph object within jsps.<br />
Next you may want to set the properties of the graph by giving it a customized look.  Please refer to the Chart XML API found in <a href="http://www.fusioncharts.com/docs" target="_blank">http://www.fusioncharts.com/docs</a> for the properties you can customize.</p>
<p>For example if I wanted to set the background of the graph to a gradient of white and yellow I would do this:</p>
<blockquote><p>graph.setChartProperties(“bgColor”,”FFFFFF,CCCC33”);</p></blockquote>
<p>You will also want to set the width and height of the graph by using the <em>setWidth(int)</em> and <em>setHeight(int)</em> methods, or just go with the default which is width=600, height=300.<br />
<img class="alignleft size-full wp-image-190" title="guide1" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/guide1.jpg" alt="" width="618" height="506" /><br />
Now to create a series inside the graph:</p>
<blockquote><p>Series series = graph.createSeries(“pieSeries”);</p></blockquote>
<p><img class="alignleft size-full wp-image-192" title="guide2" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/guide2.jpg" alt="" width="738" height="97" /></p>
<h3><span style="color: #3366ff;"><strong>Series</strong></span></h3>
<p>You will have one or more series containing data.</p>
<p>The series object has a set of member properties that you can set.  Please refer to the API for more information.</p>
<p>For the pie graph you will probably want to set the values, and the colors for each pie.<br />
To do this you can use the <span style="color: red;">setColor(int index, String color)</span> and <span style="color: red;">setValue(int index, double value)</span> methods.<br />
<img class="alignleft size-full wp-image-193" title="guide3" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/guide3.jpg" alt="" width="835" height="147" /></p>
<h3><span style="color: #3366ff;"><strong>ChartFactory</strong></span></h3>
<p>When you are finished creating the graph, you will want to put the graph in a ChartFactory so that the Chart Factory can build the desired xml string for the data.  To generate the data for the pie graph, code the following:</p>
<blockquote><p>ChartFactory chartFactory = new ChartFactory();<br />
chartFactory.insertGraph(pieGraph);<br />
chartFactory.buildFusionChart(“pieGraph”); //or use pieGraph.getGraphId() for the String parameter</p></blockquote>
<p>A new method called “buildDOMFusionChart(String graphName) was created so that we could utilize the FusionChartsDOM_commented.js which allows us to use an html tag to display the fusion chart.</p>
<p>All you need to do is add the following line instead of “chartFactory.buildFusionChart(“pieGraph”)</p>
<p>You would use on the jsp</p>
<blockquote><p>chartFactory.buildDOMFusionChart(“pieGraph”);</p></blockquote>
<p><img class="alignleft size-full wp-image-195" title="guide4" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/guide4.jpg" alt="" width="819" height="383" /></p>
<p>You will need to include in your body tag</p>
<blockquote><p><span style="color: #ff0000;">&lt;body onload=&#8221;setTimeout(&#8216;FusionChartsDOM.RenderAllCharts(true)&#8217;,1000)&#8221;&gt;</span></p></blockquote>
<p>In addition make sure you have the scripts loaded into your jsp if you are using jsp</p>
<blockquote><p>&lt;SCRIPT LANGUAGE=&#8221;Javascript&#8221; SRC=&#8221;/FusionCharts/FusionCharts.js&#8221;&gt;&lt;/SCRIPT&gt;</p>
<p>&lt;script type=&#8221;text/javascript&#8221; src=&#8221;/FusionCharts/FusionChartsDOM_commented.js&#8221;&gt;&lt;/script&gt;</p></blockquote>
<p><img class="alignleft size-full wp-image-196" title="guide5" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/guide5.jpg" alt="" width="799" height="196" /></p>
<h3><span style="color: #3366ff;"><strong>Using the helper chartBuilder.jsp</strong></span></h3>
<p>The chartBuilder.jsp has built in Javascript that works with FusionCharts.js and renders the chart for you provided that you provide the correct graph parameter.  You can either use this method or the buildDOMFusionChart method which is newer.</p>
<p>All you need to do is provide the graphId of the graph you want to display</p>
<p>For example if I wanted to display the pie graph from the earlier examples, I would do this</p>
<blockquote><p>&lt;jsp:include page=”/tools/chartBuilder.jsp” flush=”true”&gt;</p>
<p>&lt;jsp:param name=”graphId” value=”pieGraph”/&gt;</p>
<p>//or use &lt;%=pieGraph.getGraphId() %&gt; instead of the string</p>
<p>&lt;/jsp:include&gt;</p></blockquote>
<p><span style="color: #ff0000;"><em><strong>Note: You must use example_alternative.jsp to see this</strong></em></span><br />
<img class="alignleft size-full wp-image-197" title="guide6" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/guide6.jpg" alt="" width="705" height="408" /></p>
<h3><strong>Example.jsp and example_alternative.jsp</strong></h3>
<p>Please take a look at the example.jsp attached that will help you build a pie graph using the DOM method.  Example_alternative.jsp provides an example of building a chart using the chartBuilder.jsp method.  The drawback of using the chartBuilder.jsp method is that you make another server call when calling that jsp.  So with pages that have many charts, it will be better using the DOM method.</p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/ErVfvIjv9MM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2010/02/03/fusion-charts-wrapper-online-guide/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2010/02/03/fusion-charts-wrapper-online-guide/</feedburner:origLink></item>
		<item>
		<title>Fusion Charts Java Wrapper Updated</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/Pd425rBh4VE/</link>
		<comments>http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/#comments</comments>
		<pubDate>Tue, 02 Feb 2010 07:02:10 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Fusion Charts]]></category>
		<category><![CDATA[Fusion Charts Documentation]]></category>
		<category><![CDATA[Installation]]></category>
		<category><![CDATA[Java Wrapper]]></category>

		<guid isPermaLink="false">http://davidlai101.com/blog/?p=157</guid>
		<description><![CDATA[Fusion Charts Java Wrapper v1.0 released
I&#8217;ve updated the fusion charts java wrapper that I released in a previous post, however many people were having problems getting to work, so I&#8217;ve changed some stuff around and updated the wrapper with clear instructions on getting it to work for everyone.
The FusionCharts wrapper requires Java 1.5+ in order [...]]]></description>
			<content:encoded><![CDATA[<p><strong>Fusion Charts Java Wrapper v1.0 released</strong></p>
<p>I&#8217;ve updated the fusion charts java wrapper that I released in a previous post, however many people were having problems getting to work, so I&#8217;ve changed some stuff around and updated the wrapper with clear instructions on getting it to work for everyone.</p>
<p>The FusionCharts wrapper requires Java 1.5+ in order to run so make sure you have this set in the compile settings.<br />
The package was tested on Eclipse JEE Galileo where you can download at the Eclipse website <a href="http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/galileo/SR1/eclipse-jee-galileo-SR1-win32.zip" target="_blank">here</a><br />
With the Web Tools Platform 3.1.1 addon <a href="http://download.eclipse.org/webtools/downloads/" target="_blank">here</a><br />
In addition please install Tomcat which can be found <a href="http://tomcat.apache.org/download-60.cgi" target="_blank">here</a></p>
<p>I&#8217;ve released 4 versions that you can download ranging from the full source to just a war file.<br />
Please click on the links to download your desired version<br />
<a href="http://www.davidlai101.com/blog/media/blogs/bobj/fusioncharts/1.0/fusioncharts-fullsource.war">FusionCharts War File (web project)</a><br />
<a href="http://www.davidlai101.com/blog/media/blogs/bobj/fusioncharts/1.0/fusioncharts-fullsource.zip">FusionCharts Full Source (web project)</a><br />
<a href="http://www.davidlai101.com/blog/media/blogs/bobj/fusioncharts/1.0/fusioncharts.jar">FusionCharts Jar File</a><br />
<a href="http://www.davidlai101.com/blog/media/blogs/bobj/fusioncharts/1.0/fusioncharts-fullsource-code.zip">FusionCharts Full Source</a><br />
<a href="http://davidlai101.com/fusioncharts-javadoc/">Java Docs</a></p>
<p><strong>Part 1: Installation</strong><br />
<span id="more-157"></span><br />
I&#8217;ll explain how to install each version now.<br />
<strong>1.  Make sure your compiler is set to Java 1.5 or higher</strong><br />
<img class="alignleft size-full wp-image-159" title="java-compiler" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/java-compiler.jpg" alt="" width="530" height="569" /></p>
<p><strong>2.  Make sure your buildpath is using a Java runtime of 5.0 or higher</strong><br />
<img class="alignleft size-full wp-image-161" title="java-build-path" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/java-build-path.jpg" alt="" width="828" height="646" /></p>
<p><strong>3.  If you are using the WAR or the fullsource web project file (make sure you have unzipped it to your workspace), right click on the project explorer and select import either WAR or existing projects into workspace.<br />
</strong><br />
<img class="alignleft size-full wp-image-163" title="java-importwar" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/java-importwar.jpg" alt="" width="655" height="581" /><br />
If you are using the JAR file, make sure you also import the jar into your WEB-INF lib folder<br />
<img class="size-full wp-image-164  alignnone" style="margin-left: 150px; margin-right: 150px;" title="webinf" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/webinf.jpg" alt="" width="263" height="254" /></p>
<p><strong>4. GREAT! now if you want you can try running the examples</strong><br />
Start your tomcat server by right clicking on your project -&gt; run as -&gt; run on server.  Then select Tomcat and the location where you installed tomcat.<br />
<img class="alignleft size-full wp-image-169" title="java-runserver" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/java-runserver.jpg" alt="" width="725" height="667" /></p>
<p>Finally go to your browser of choice and test out the example_alternative.jsp<br />
<img class="alignleft size-full wp-image-170" title="fusionfullsourcefinal" src="http://davidlai101.com/blog/wp-content/uploads/2010/02/fusionfullsourcefinal.jpg" alt="" width="738" height="310" /></p>
<p>For instructions on using the wrapper please click on my next post <a href="http://davidlai101.com/blog/2010/02/03/fusion-charts-wrapper-online-guide/">here</a><br />
or you can download the user guide <a href="http://www.davidlai101.com/blog/media/blogs/bobj/fusioncharts/1.0/FusionCharts_Userguide1.3.doc">here</a></p>
<p>In addition click <a href="http://davidlai101.com/fusioncharts-javadoc/">here</a> to access the Java Docs</p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/Pd425rBh4VE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/</feedburner:origLink></item>
		<item>
		<title>New Look for 2010!</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/V7kAxwsoDG4/</link>
		<comments>http://davidlai101.com/blog/2010/01/23/new-look-for-2010/#comments</comments>
		<pubDate>Sat, 23 Jan 2010 09:12:37 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://davidlai101.com/bobjblog/?p=127</guid>
		<description><![CDATA[
First of all, I&#8217;d like to wish all my readers a happy 2010 and Thank you for continuing to visit my blog.  I&#8217;ve had some busy projects this year and I apologize for the lack of posts, however my new years resolution is to be more proactive this year on my posts  
I&#8217;ve [...]]]></description>
			<content:encoded><![CDATA[<p><img class="alignleft size-medium wp-image-128" style="margin-left: 120px; margin-right: 120px;" title="Wordpress" src="http://davidlai101.com/blog/wp-content/uploads/2010/01/wp-300x300.jpg" alt="" width="300" height="300" /></p>
<p>First of all, I&#8217;d like to wish all my readers a happy 2010 and Thank you for continuing to visit my blog.  I&#8217;ve had some busy projects this year and I apologize for the lack of posts, however my new years resolution is to be more proactive this year on my posts <img src='http://davidlai101.com/blog/wp-includes/images/smilies/icon_smile.gif' alt=':)' class='wp-smiley' /> </p>
<p>I&#8217;ve finally finished migrating my blog from b2evolution to Wordpress, although there&#8217;s a few kinks I need to sort out with the widgets.  I&#8217;m really enjoying the flexibility and amount of plug-ins available for Wordpress. <img src='http://davidlai101.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' /> </p>
<p>I hope you enjoy the new look, and any comments/feedback would be greatly appreciated so that I can continue making everyone&#8217;s reading experience as enjoyable as possible</p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/V7kAxwsoDG4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2010/01/23/new-look-for-2010/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2010/01/23/new-look-for-2010/</feedburner:origLink></item>
		<item>
		<title>Inovista Microcharts part 2</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/K9aG9l0hA3s/</link>
		<comments>http://davidlai101.com/blog/2009/10/20/inovista-microcharts-part-2/#comments</comments>
		<pubDate>Tue, 20 Oct 2009 07:03:50 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Main]]></category>
		<category><![CDATA[expand]]></category>
		<category><![CDATA[imt slider]]></category>
		<category><![CDATA[inovista]]></category>
		<category><![CDATA[microcharts]]></category>
		<category><![CDATA[sorting]]></category>
		<category><![CDATA[tree grid]]></category>
		<category><![CDATA[Xcelsius]]></category>

		<guid isPermaLink="false" />
		<description><![CDATA[In my previous article I gave an overview of the Microcharts plug-in for Xcelsius and a quick example of creating a Microcharts Datatable.  In addition, I explained how to replicate the same example in Xcelsius using workarounds that would make development much more timely and harder to maintain.
In this article I would like to [...]]]></description>
			<content:encoded><![CDATA[<p>In my previous article I gave an overview of the Microcharts plug-in for Xcelsius and a quick example of creating a Microcharts Datatable.  In addition, I explained how to replicate the same example in Xcelsius using workarounds that would make development much more timely and harder to maintain.</p>
<p>In this article I would like to talk about some important features that Inovista Microcharts has that Xcelsius cannot reproduce.  A very important table component that Xcelsius lacks is the ability to expand and contract your rows like a tree.  Inovista has a component called a &#8220;Microchart Tree Grid&#8221; that allows a user to expand and contract rows so that users can group their rows accordingly.  This is extremely important if we don&#8217;t want to clutter a table view with too many rows.<br />
<span id="more-8"></span></p>
<p>Below is a sample that I have taken from the Inovista website that shows a Tree table in action.</p>

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
			id="fm_treegrid_292148173"
			class="flashmovie"
			width="550"
			height="500">
	<param name="movie" value="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/treegrid.swf " />
	<!--[if !IE]>-->
	<object	type="application/x-shockwave-flash"
			data="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/treegrid.swf "
			name="fm_treegrid_292148173"
			width="550"
			height="500">
	<!--<![endif]-->
		<a href="http://adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a><br />

	<!--[if !IE]>-->
	</object>
	<!--<![endif]-->
</object>
<p>Looking further into the example, there are 2 additional components inside the tree table that Xcelsius cannot reproduce.  First of all, Xcelsius does not have the ability to create a bulletgraph, which is quite a popular item used in dashboards.  In addition, the ability to create checkmarks and other shapes would be very hard to reproduce in Xcelsius; thus is another component lacking in Xcelsius since many dashboards contain checkmarks and stars for ratings.  The option to put the x-axis scale on the header or y-axis scale on each graph is also a useful feature that Inovista provides for the Microcharts table and Microcharts treegrid.  Finally the ability to move the columns around is also another useful feature that Xcelsius does not allow.</p>
<p>There are however, a few problems that remain with the treegrid which comes mainly from the column sorting ability.  Please use the example below as a reference.<br />

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
			id="fm_example_2118467848"
			class="flashmovie"
			width="550"
			height="500">
	<param name="movie" value="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/example.swf" />
	<!--[if !IE]>-->
	<object	type="application/x-shockwave-flash"
			data="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/example.swf"
			name="fm_example_2118467848"
			width="550"
			height="500">
	<!--<![endif]-->
		<a href="http://adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a><br />

	<!--[if !IE]>-->
	</object>
	<!--<![endif]-->
</object><br />
The first problem comes from the fact that sorting only occurs alphabetically and cannot be modified to be sorted numerically.  For example if we have the following numbers 1, 2, 19; the sort order will be 1, 19, 2 which is incorrect.  The next problem is that the Microcharts treegrid doesn&#8217;t sort by parent and then child.  For example if you expand the parent nodes and try to sort the items, the result will be a messed up list where child nodes are all over the place.</p>
<p>Sorting is an important element but not a show stopper so hopefully the author fixes these problems for the next Inovista release.</p>
<p>The final important feature that Inovista provides that Xcelsius cannot reproduce is the IMT slider, which is similar to the slider that you find in the finance.google.com charts and biz.yahoo.com charts.  This is extremely useful as it allows users to intuitively view a window of time that they are interested in.<br />

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
			id="fm_imtslider_182978556"
			class="flashmovie"
			width="550"
			height="500">
	<param name="movie" value="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/imtslider.swf" />
	<!--[if !IE]>-->
	<object	type="application/x-shockwave-flash"
			data="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/imtslider.swf"
			name="fm_imtslider_182978556"
			width="550"
			height="500">
	<!--<![endif]-->
		<a href="http://adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a><br />

	<!--[if !IE]>-->
	</object>
	<!--<![endif]-->
</object>
<input id="gwProxy" type="hidden" />
<input id="jsProxy" onclick="jsCall();" type="hidden" />
<input id="gwProxy" type="hidden" />
<input id="jsProxy" onclick="jsCall();" type="hidden" />
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/K9aG9l0hA3s" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2009/10/20/inovista-microcharts-part-2/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2009/10/20/inovista-microcharts-part-2/</feedburner:origLink></item>
		<item>
		<title>Introduction to Inovista Microcharts</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/JWgKMYKBDv4/</link>
		<comments>http://davidlai101.com/blog/2009/10/16/introduction-to-inovista-microcharts/#comments</comments>
		<pubDate>Fri, 16 Oct 2009 06:38:24 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Xcelsius]]></category>
		<category><![CDATA[bonavista]]></category>
		<category><![CDATA[bulletgraph]]></category>
		<category><![CDATA[datatable]]></category>
		<category><![CDATA[inovista]]></category>
		<category><![CDATA[microcharts]]></category>
		<category><![CDATA[sparkline]]></category>

		<guid isPermaLink="false" />
		<description><![CDATA[For those of you who have seen or used Bonavistas Microcharts on Excel http://www.bonavistasystems.com/.  You&#8217;ll appreciate how you can show a huge amount of data on the screen without becoming too overwhelming to the end user.  Using data tables with sparklines, bulletgraphs, etc puts data in a format where it is easy to [...]]]></description>
			<content:encoded><![CDATA[<p>For those of you who have seen or used Bonavistas Microcharts on Excel <a href="http://www.bonavistasystems.com/" target="_blank">http://www.bonavistasystems.com/</a>.  You&#8217;ll appreciate how you can show a huge amount of data on the screen without becoming too overwhelming to the end user.  Using data tables with sparklines, bulletgraphs, etc puts data in a format where it is easy to read for the human eye.<br />

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
			id="fm_MovingTitles_1169424461"
			class="flashmovie"
			width="500"
			height="250">
	<param name="movie" value="http://www.inovista.com/MovingTitles.swf" />
	<!--[if !IE]>-->
	<object	type="application/x-shockwave-flash"
			data="http://www.inovista.com/MovingTitles.swf"
			name="fm_MovingTitles_1169424461"
			width="500"
			height="250">
	<!--<![endif]-->
		
<p><a href="http://adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p>

	<!--[if !IE]>-->
	</object>
	<!--<![endif]-->
</object>
<p>Microcharts for Xcelsius provides us with the advanced table features that Xcelsius lacks.  Well there are Xcelsius workarounds that can produce similar results but at the cost of performance, maintainance and formatting problems.</p>
<p><span id="more-12"></span><br />
Microcharts is still fairly new so there a few bugs that you will encounter, but if you contact the author, he responds very quickly and is very helpful.  In addition, I found that when it first loads with Xcelsius, it takes a very long time.  Navigating through the data table properties was a little confusing but once you get used to it, it&#8217;s okay.  Finally the objects in Microcharts lack the wow effect that the built in Xcelsius objects have.</p>
<p>In this article we will go through an example of the Microcharts data table with items that can be reproducible in Xcelsius and the consequences of using workarounds to produce the same end product.  Feel free to play around with the table below by sorting and moving the columns around.</p>

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
			id="fm_datatabledemo_1010100398"
			class="flashmovie"
			width="500"
			height="300">
	<param name="movie" value="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatabledemo.swf" />
	<!--[if !IE]>-->
	<object	type="application/x-shockwave-flash"
			data="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatabledemo.swf"
			name="fm_datatabledemo_1010100398"
			width="500"
			height="300">
	<!--<![endif]-->
		
<p><a href="http://adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p>

	<!--[if !IE]>-->
	</object>
	<!--<![endif]-->
</object><br />
The example comprises of a microcharts table that has 5 columns.  The first column will contain the part type (text).  The second column will contain the number of total parts for that part type (number).  The 3rd column will contain a monthly trend of defective parts for the part type (sparkline).  The 4th column will contain the number of current defective parts (number).  The firth column will contain an alert circle where green meets the defect threshold, yellow is borderline, and red falls below the threshold (shape object).</p>
<p>To accomplish this, We would first select the &#8220;MicroChart Table&#8221; object from &#8220;Inovista Grids&#8221;</p>
<p><img src="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatable1.png" alt="create data table" title="create microchart table" /></p>
<p>Next we would add the 5 columns.  In the properties window, Click on the &#8220;General&#8221; icon on the top left and the &#8220;Chart Columns&#8221; tab.  Insert each column by pressing the insert button on the Data window.  Once that has been completed, we want to change each chart type to the appropriate type and set the header text accordingly.  For text and numbers choose the &#8220;TextNumberIndicatorChart&#8221; type.  For sparklines choose the &#8220;MicroLineChart&#8221; type.  Finally for the alert circle, choose the &#8220;ShapeIndicatorChart&#8221; type.</p>
<p><img src="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatable2.png" alt="setup columns" title="setup columns" /></p>
<p>Now we want to set the data values for each column.  To accomplish this, just scroll down to the Data Source column and enter your values in either the Chart Data or Text Value sections.  Because each column is independant to each other, we can put the data where ever we want on the spreadsheet. </p>
<p><img src="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatable3.png" alt="setup chart data" title="setup chart data" /></p>
<p>The next screenshot shows how we can further organize our data by putting the sparkline data in a seperate worksheet.<br />
<img src="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatable4.png" alt="sparkline data" title="sparkline data" /></p>
<p>If you notice, we are able to manage multiple columns and charts in just one component in a very efficient manner.  Now let&#8217;s talk about how we can replicate this using Xcelsius workarounds.</p>
<p>To emulate the table structure we will first need a table object and have the values formatted accordingly on the Excel spreadsheet.  You will need to leave blank spaces on the columns that contain the sparklines and alert circles.  You&#8217;ll notice that it will take a decent amount of time to play around and get the formatting correct.</p>
<p>Once that is finished, you&#8217;ll need to create and and setup all the sparkline charts.  If you&#8217;re table contains 10 rows, you&#8217;ll need to create and setup 10 sparkline charts.  Just think about how long it will take to fill out the data source values, size the charts and fit them carefully onto the data table.</p>
<p>Finally you&#8217;ll need to insert the alert circles and to do this you can simply use the label based menu trick found on <a href="http://ryangoodman.net/blog/index.php/2008/03/23/build_a_scorecard_using_new_xcelsius_200" target="_blank">Ryan Goodman&#8217;s blog</a>.  However with this method, the sizing of the label based menu object and table on the design screen is different than what you see when the swf has been exported.  Thus when creating scorecards, sometimes you&#8217;ll need to spend alot of time playing with the object sizing in order to get things looking correct.</p>
<p>In conclusion, my thoughts on Microcharts is that it provides a powerful addon to Xcelsius on representing data in a manner where users can read what is going on very easily.  Although it provides some stress on the development environment, is a little bit buggy, and performance hasn&#8217;t really been compared at an enterprise scale level, the benefits that it offers in my opinion outweighs the negatives.  The amount of time developers can save from maintaince problems and development time is huge.  The author of the product, is extremely responsive to any bug reports and will usually answer or even &#8220;FIX&#8221; any problems within the same day of contacting the author which is great.  As the microcharts plug-in matures, hopefully the bugs will be ironed out and the look and feel will be improved.</p>
<p>In my next article about Microcharts, I will speak about some of the components that users may find very powerful which cannot be emulated using Xcelsius.</p>
<p>You can download the xlf and swf source file <a href="http://www.davidlai101.com/blog/media/blogs/bobj/microcharts/datatabledemo.zip" target="_blank">here</a></p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/JWgKMYKBDv4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2009/10/16/introduction-to-inovista-microcharts/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2009/10/16/introduction-to-inovista-microcharts/</feedburner:origLink></item>
		<item>
		<title>BEWARE OF FREDERICK CARTER (Pathway Technologies Inc)</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/sF5QIUBcgDQ/</link>
		<comments>http://davidlai101.com/blog/2009/08/11/beware-of-frederick-carter-pathway-techn/#comments</comments>
		<pubDate>Tue, 11 Aug 2009 15:30:18 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Main]]></category>
		<category><![CDATA[dianne sawyer]]></category>
		<category><![CDATA[fannie mae]]></category>
		<category><![CDATA[fred carter]]></category>
		<category><![CDATA[frederick carter]]></category>
		<category><![CDATA[pathway technologies]]></category>
		<category><![CDATA[ripoff]]></category>
		<category><![CDATA[scam]]></category>

		<guid isPermaLink="false" />
		<description><![CDATA[This is a warning to all consultants and anyone who has professional contact with Frederick Carter.
I&#8217;ve worked with many clients in the BI and BOBJ industry and unfortunately this is the first customer that I have provided services for who ran away without paying.  Apparently Frederick needed some work accomplished in a short period [...]]]></description>
			<content:encoded><![CDATA[<p>This is a warning to all consultants and anyone who has professional contact with Frederick Carter.</p>
<p>I&#8217;ve worked with many clients in the BI and BOBJ industry and unfortunately this is the first customer that I have provided services for who ran away without paying.  Apparently Frederick needed some work accomplished in a short period of time and I was generous enough to complete a week&#8217;s worth of Xcelsius work without even taking a deposit.</p>
<p>Luckily, towards the end of a week&#8217;s work, I accidentally heard one of his conversations with his accomplice &#8220;Dianne Sawyer&#8221; saying that he was going to stiff me and not pay.  In addition, he said that &#8220;The client he was trying to score the contract with thinks that all the Xcelsius work was done by him, and that he could learn how to be an Xcelsius and Business Objects expert in 1 week&#8221;.  I called him up on this and he kept making excuses that he was having cash flow problems.  He said that he would promise to pay if I would do a few more hours of work for him so that he could score a contract with Fannie Mae.  So, out of sympathy I completed a few hours of work for him and after the work was completed, he started ignoring my emails and phone calls regarding payment.</p>
<p>After he found out he got kicked out of the linked in group &#8220;Xcelsius Gurus&#8221; since he ripped off another Xcelsius Consultant &#8220;Kalyan Verma&#8221;, he started begging me to get him back into the group and offered to pay off his debt in payments.  I was nice enough to agree and he paid an initial payment of $200.  However a week later he purposely closed his account on paypal and the $200 payment got reversed.</p>
<p>After that he has ignored all calls and emails.</p>
<p>I hope this posting will expose and help prevent Frederick Carter from ripping off anymore consultants and businesses since we all work hard for our living.  For those who are interested, I have all the chat logs and emails sent back and forth between us to prove everything that happened.</p>
<p>Here is a link to his linked-in profile</p>
<p>http://www.linkedin.com/in/frederickcarter</p>
<p>His Corporation is <b>Pathway Technologies Inc.</b><br />
His Accomplice is <b>Dianne Sawyer</b></p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/sF5QIUBcgDQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2009/08/11/beware-of-frederick-carter-pathway-techn/feed/</wfw:commentRss>
		<slash:comments>5</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2009/08/11/beware-of-frederick-carter-pathway-techn/</feedburner:origLink></item>
		<item>
		<title>Simulating Excel Conditional Formatting in Xcelsius</title>
		<link>http://feedproxy.google.com/~r/DavidLaisBusinessIntelligenceBlog/~3/tM6mIFW59RI/</link>
		<comments>http://davidlai101.com/blog/2009/08/09/simulating-excel-conditional-formatting/#comments</comments>
		<pubDate>Mon, 10 Aug 2009 03:04:11 +0000</pubDate>
		<dc:creator>David Lai</dc:creator>
				<category><![CDATA[Tips and Tricks]]></category>
		<category><![CDATA[Xcelsius]]></category>
		<category><![CDATA[conditional formatting]]></category>
		<category><![CDATA[Excel]]></category>
		<category><![CDATA[grid component]]></category>
		<category><![CDATA[table]]></category>

		<guid isPermaLink="false" />
		<description><![CDATA[Conditional formatting in Excel is a feature that is very commonly used and very useful in displaying how well a set of values in a table are doing.  Unfortunately we can not transfer the dynamic nature of conditional formatting from Excel to Xcelsius if we were to just insert the table selector object.  [...]]]></description>
			<content:encoded><![CDATA[<p>Conditional formatting in Excel is a feature that is very commonly used and very useful in displaying how well a set of values in a table are doing.  Unfortunately we can not transfer the dynamic nature of conditional formatting from Excel to Xcelsius if we were to just insert the table selector object.  Basically if the initial binding color of a cell was <b>&#8220;Green&#8221;</b>, it would stay green even though it were to change to <b>&#8220;Red&#8221;</b> when the value changes.</p>
<p>Please view my video on how to simply accomplish this using a grid component in Xcelsius</p>
<p><!-- Smart Youtube --><span class="youtube"><object width="425" height="355"><param name="movie" value="http://www.youtube.com/v/2oxXZrvxOb4&amp;rel=1&amp;color1=d6d6d6&amp;color2=f0f0f0&amp;border=0&amp;fs=1&amp;hl=en&amp;autoplay=0&amp;showinfo=0&amp;iv_load_policy=3&amp;showsearch=0" /><param name="allowFullScreen" value="true" /><embed wmode="transparent" src="http://www.youtube.com/v/2oxXZrvxOb4&amp;rel=1&amp;color1=d6d6d6&amp;color2=f0f0f0&amp;border=0&amp;fs=1&amp;hl=en&amp;autoplay=0&amp;showinfo=0&amp;iv_load_policy=3&amp;showsearch=0" type="application/x-shockwave-flash" allowfullscreen="true" width="425" height="355" ></embed><param name="wmode" value="transparent" /></object></span><a href="http://www.youtube.com/watch?v=2oxXZrvxOb4"><img src="http://img.youtube.com/vi/2oxXZrvxOb4/default.jpg" width="130" height="97" border=0></a></p>
<p>Please visit my post on <a href="http://myxcelsius.com/2009/07/27/simulated-conditional-formatting-part-2/" target="_blank">&#8220;MyXcelsius&#8221;</a> for a more advanced example of conditional formatting in Xcelsius involving dynamic sliders and charts.</p>
<p>You can download the source file for the example <a href="http://www.davidlai101.com/blog/media/blogs/bobj/simulated_conditional_formatting/conditional%20formatting%20part%202.zip" title="">here</a></p>
<img src="http://feeds.feedburner.com/~r/DavidLaisBusinessIntelligenceBlog/~4/tM6mIFW59RI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://davidlai101.com/blog/2009/08/09/simulating-excel-conditional-formatting/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://davidlai101.com/blog/2009/08/09/simulating-excel-conditional-formatting/</feedburner:origLink></item>
	</channel>
</rss>
