tag:blogger.com,1999:blog-9733934268340828112024-03-13T13:07:09.160-07:00PentahoMukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-973393426834082811.post-34110934087355690732016-07-19T01:19:00.001-07:002016-07-19T01:19:34.718-07:00How To Connect MySQL Database <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<div class="post-outer" style="border-bottom-color: rgb(219, 219, 219); border-bottom-style: solid; border-bottom-width: 1px; border-top-style: none; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; padding: 0px 0px 10px;">
<div class="post hentry uncustomized-post-template" itemprop="blogPost" itemscope="itemscope" itemtype="http://schema.org/BlogPosting" style="min-height: 0px; position: relative;">
<div class="post-body entry-content" id="post-body-2545353057002618134" itemprop="description articleBody" style="line-height: 1.4; width: 530px;">
<div dir="ltr" trbidi="on">
<span style="background-color: white;"><br /> How to create report in pentaho from exiting MySQL datatables .<br />step 1. Log in pentaho .<br />setp2. From Home select create new -> data source -> put name datademo , select reporting and analysis and click next<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-zRouBvrUlSE/Ve_BfQyzC0I/AAAAAAAAANs/t6PEMrDYO4U/s1600/p4.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://3.bp.blogspot.com/-zRouBvrUlSE/Ve_BfQyzC0I/AAAAAAAAANs/t6PEMrDYO4U/s320/p4.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br />step 3- select one table from the table to another box. select fact table. Then finish .<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-9wlmGR-3hPw/Ve_BkcHgk_I/AAAAAAAAAN0/9WT0-HfagPQ/s1600/p55.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://3.bp.blogspot.com/-9wlmGR-3hPw/Ve_BkcHgk_I/AAAAAAAAAN0/9WT0-HfagPQ/s320/p55.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br />step 4 - Now create new - intractive report ->then select datademo then ok .</span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-xDsLpxJmhR8/Ve_B-ffOaQI/AAAAAAAAAN8/y5vP8nIGN0w/s1600/p66.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-xDsLpxJmhR8/Ve_B-ffOaQI/AAAAAAAAAN8/y5vP8nIGN0w/s320/p66.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br />strp5- Now all data fileld you can see then drag and drop to create report then save .<br /><br /> </span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-kqtCBU_Dpng/Ve_CFRFSGSI/AAAAAAAAAOE/_lpW9GBbCkM/s1600/p77.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-kqtCBU_Dpng/Ve_CFRFSGSI/AAAAAAAAAOE/_lpW9GBbCkM/s320/p77.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
</div>
<div style="clear: both;">
</div>
</div>
<div class="post-footer" style="line-height: 1.6; margin: 1.5em 0px 0px;">
<div class="post-footer-line post-footer-line-1">
<span style="background-color: white;"><span class="post-author vcard" style="margin-left: 0px; margin-right: 1em;">Posted by <span class="fn" itemprop="author" itemscope="itemscope" itemtype="http://schema.org/Person"><a class="g-profile" data-gapiattached="true" data-gapiscan="true" data-onload="true" href="https://plus.google.com/104601204979787913187" rel="author" style="color: #4d469c; text-decoration: none;" title="author profile"><span itemprop="name">Mukesh Jha</span> </a></span></span><span class="post-timestamp" style="margin-left: -1em; margin-right: 1em;">at <a class="timestamp-link" href="http://pentahofaq.blogspot.in/2015/09/how-to-create-report-in-pentaho-from.html" rel="bookmark" style="color: #4d469c; text-decoration: none;" title="permanent link"><abbr class="published" itemprop="datePublished" style="border: none;" title="2015-09-08T22:23:00-07:00">10:23 PM</abbr></a> </span><span class="reaction-buttons" style="margin-right: 1em;"></span><span class="post-comment-link" style="margin-right: 1em;"><a class="comment-link" href="http://pentahofaq.blogspot.in/2015/09/how-to-create-report-in-pentaho-from.html#comment-form" style="color: #4d469c; text-decoration: none; white-space: nowrap;">No comments: </a></span><span class="post-backlinks post-comment-link" style="margin-right: 1em;"></span><span class="post-icons" style="margin-right: 1em;"><span class="item-control blog-admin pid-1735533266" style="display: inline;"><a href="https://www.blogger.com/post-edit.g?blogID=4894446511032085183&postID=2545353057002618134&from=pencil" style="color: #4d469c; text-decoration: none;" title="Edit Post"><img alt="" class="icon-action" height="18" src="https://resources.blogblog.com/img/icon18_edit_allbkg.gif" style="border: none; margin: 0px 0px 0px 0.5em !important; position: relative; vertical-align: middle;" width="18" /></a></span></span><div class="post-share-buttons goog-inline-block" style="display: inline-block; margin-right: 0px; margin-top: 0.5em; position: relative; vertical-align: middle;">
<a class="goog-inline-block share-button sb-email" href="https://www.blogger.com/share-post.g?blogID=4894446511032085183&postID=2545353057002618134&target=email" style="background-attachment: initial !important; background-clip: initial !important; background-image: url("/img/share_buttons_20_3.png") !important; background-origin: initial !important; background-position: 0px 0px !important; background-repeat: no-repeat !important; background-size: initial !important; color: #4d469c; display: inline-block; height: 20px; margin-left: -1px; overflow: hidden; position: relative; text-decoration: none; width: 20px;" target="_blank" title="Email This"><span class="share-button-link-text" style="display: block; text-indent: -9999px;">Email This</span></a><a class="goog-inline-block share-button sb-blog" href="https://www.blogger.com/share-post.g?blogID=4894446511032085183&postID=2545353057002618134&target=blog" style="background-attachment: initial !important; background-clip: initial !important; background-image: url("/img/share_buttons_20_3.png") !important; background-origin: initial !important; background-position: -20px 0px !important; background-repeat: no-repeat !important; background-size: initial !important; color: #4d469c; display: inline-block; height: 20px; margin-left: -1px; overflow: hidden; position: relative; text-decoration: none; width: 20px;" target="_blank" title="BlogThis!"><span class="share-button-link-text" style="display: block; text-indent: -9999px;">BlogThis!</span></a><a class="goog-inline-block share-button sb-twitter" href="https://www.blogger.com/share-post.g?blogID=4894446511032085183&postID=2545353057002618134&target=twitter" style="background-attachment: initial !important; background-clip: initial !important; background-image: url("/img/share_buttons_20_3.png") !important; background-origin: initial !important; background-position: -40px 0px !important; background-repeat: no-repeat !important; background-size: initial !important; color: #4d469c; display: inline-block; height: 20px; margin-left: -1px; overflow: hidden; position: relative; text-decoration: none; width: 20px;" target="_blank" title="Share to Twitter"><span class="share-button-link-text" style="display: block; text-indent: -9999px;">Share to Twitter</span></a><a class="goog-inline-block share-button sb-facebook" href="https://www.blogger.com/share-post.g?blogID=4894446511032085183&postID=2545353057002618134&target=facebook" style="background-attachment: initial !important; background-clip: initial !important; background-image: url("/img/share_buttons_20_3.png") !important; background-origin: initial !important; background-position: -60px 0px !important; background-repeat: no-repeat !important; background-size: initial !important; color: #4d469c; display: inline-block; height: 20px; margin-left: -1px; overflow: hidden; position: relative; text-decoration: none; width: 20px;" target="_blank" title="Share to Facebook"><span class="share-button-link-text" style="display: block; text-indent: -9999px;">Share to Facebook</span></a><a class="goog-inline-block share-button sb-pinterest" href="https://www.blogger.com/share-post.g?blogID=4894446511032085183&postID=2545353057002618134&target=pinterest" style="background-attachment: initial !important; background-clip: initial !important; background-image: url("/img/share_buttons_20_3.png") !important; background-origin: initial !important; background-position: -100px 0px !important; background-repeat: no-repeat !important; background-size: initial !important; color: #4d469c; display: inline-block; height: 20px; margin-left: -1px; overflow: hidden; position: relative; text-decoration: none; width: 20px;" target="_blank" title="Share to Pinterest"><span class="share-button-link-text" style="display: block; text-indent: -9999px;">Share to Pinterest</span></a><div class="goog-inline-block google-plus-share-container" style="display: inline-block; padding-left: 0.3em; position: relative; vertical-align: top;">
<div id="___plusone_4" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-style: none; display: inline-block; float: none; font-size: 1px; height: 20px; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline; width: 300px;">
<iframe data-gapiattached="true" frameborder="0" hspace="0" id="I4_1468915995803" marginheight="0" marginwidth="0" name="I4_1468915995803" scrolling="no" src="https://apis.google.com/u/0/se/0/_/+1/fastbutton?usegapi=1&source=blogger%3Ablog%3Aplusone&size=medium&width=300&annotation=inline&hl=en&origin=http%3A%2F%2Fpentahofaq.blogspot.in&url=http%3A%2F%2Fpentahofaq.blogspot.com%2F2015%2F09%2Fhow-to-create-report-in-pentaho-from.html&gsrc=3p&jsh=m%3B%2F_%2Fscs%2Fapps-static%2F_%2Fjs%2Fk%3Doz.gapi.en_GB.BSyeTWS0q5g.O%2Fm%3D__features__%2Fam%3DAQ%2Frt%3Dj%2Fd%3D1%2Frs%3DAGLTcCO3o17e1JZeI0ImN5p-lqP7T8Jd4A#_methods=onPlusOne%2C_ready%2C_close%2C_open%2C_resizeMe%2C_renderstart%2Concircled%2Cdrefresh%2Cerefresh&id=I4_1468915995803&parent=http%3A%2F%2Fpentahofaq.blogspot.in&pfname=&rpctoken=15987793" style="border-style: none; height: 20px; left: 0px; margin: 0px; position: static; top: 0px; visibility: visible; width: 300px;" tabindex="0" title="+1" vspace="0" width="100%"></iframe></div>
</div>
</div>
</span></div>
<div class="post-footer-line post-footer-line-2">
<span class="post-labels" style="background-color: white; margin-left: 0px; margin-right: 0px;"></span></div>
<div class="post-footer-line post-footer-line-3">
<span class="post-location" style="background-color: white; margin-left: 0px; margin-right: 0px;"></span></div>
</div>
</div>
</div>
<div class="post-outer" style="border-bottom-style: none; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; padding: 30px 0px 10px;">
<div class="post hentry uncustomized-post-template" itemprop="blogPost" itemscope="itemscope" itemtype="http://schema.org/BlogPosting" style="min-height: 0px; position: relative;">
<span style="background-color: white;"><a href="https://www.blogger.com/null" name="8131410970607496746"></a></span><div class="post-header" style="line-height: 1.6; margin: 0px 0px 1.5em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-8131410970607496746" itemprop="description articleBody" style="line-height: 1.4; width: 530px;">
<div dir="ltr" trbidi="on">
<span style="background-color: white;"><br /><br />How to connect MySQL with pentaho .<br />Sep1- Download pentaho BA server . http://www.pentaho.com/download.<br />step2- Insure installed Java version 7 in your system.<br />step3- Installed MYSQL and set user name and password .<br />step4- download mysql-connector-java-5.1.13-bin.jar file .<br />step5-Open Pentaho installed directory -> server-> bi-server->tomcat -> lib and paste mysql connector file file .<br />step 6-Open Pentho installed directory -> design-tools -> report-designer ->lib and paste<br /> mysql connector jar file .you can paste this jar to pentaho ->java-> lib directory.<br />step7- Log pentaho ->create new -> Datasource -> select database tables<br /><br /><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-xhV864v9HKE/Ve6gBkpWk2I/AAAAAAAAANE/uWLsvtSGaRw/s1600/p1.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-xhV864v9HKE/Ve6gBkpWk2I/AAAAAAAAANE/uWLsvtSGaRw/s320/p1.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div>
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"><br />step 8- click on add button . Then fill connection data and user name password .<br /> <br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-ZPYyHSo1PvM/Ve6gTJGvigI/AAAAAAAAANM/4QKfShiZ-GY/s1600/p2.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="250" src="https://2.bp.blogspot.com/-ZPYyHSo1PvM/Ve6gTJGvigI/AAAAAAAAANM/4QKfShiZ-GY/s400/p2.jpg" style="border: none; padding: 8px; position: relative;" width="400" /></a></div>
<span style="background-color: white;"><br /><br /><br /><br />step9- Test connection .<br /> <br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-DmwgSr9kSc4/Ve6goHvv_OI/AAAAAAAAANU/00KEhco5-UQ/s1600/p3.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-DmwgSr9kSc4/Ve6goHvv_OI/AAAAAAAAANU/00KEhco5-UQ/s320/p3.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br /> <br />setp10 - click ok you connected with MYSQL database . Now you can access the data table of schema you selected.</span></div>
</div>
</div>
</div>
</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-10034930109764592432016-07-19T01:17:00.002-07:002016-07-19T01:17:31.273-07:00Direct Log Form URL To Pentaho Server <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<br />
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> How to log directly to the pentaho server .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step 1 : Stop the BA server .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step 2: Change the URL as log for admin user .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> http://localhost:8080/pentaho/Home?userid=admin&password=password </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step 3: Go to the Pentaho\server\biserver-ee\pentaho-solutions\system then</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> security.property file .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">change as</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> -> requestParameterAuthenticationEnabled=true</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">save security.property file.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> step 4- Restart BA server test . Now you able to log directly.</span></span><div>
<span style="background-color: #fb5e53; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"><br /></span></div>
</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-79173195711642606382016-07-19T01:16:00.001-07:002016-07-19T01:16:13.418-07:00How To Create Analysis Report.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> How to create analysis reports in Pentaho .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step 1. Log pentaho -> create new -> Analysis report -></span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step2- Click data source . </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
</div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 3 - Type data source name select reporting and analysis .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://1.bp.blogspot.com/-hyRD-VGV28w/VfJxE9nh9MI/AAAAAAAAAOY/HDsLRD5h0Kk/s1600/p77.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-hyRD-VGV28w/VfJxE9nh9MI/AAAAAAAAAOY/HDsLRD5h0Kk/s320/p77.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> step 4- Select a table you want to create report .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://1.bp.blogspot.com/-wvY8AIMBCo0/VfJxbUJs60I/AAAAAAAAAOc/RiyKJWAws60/s1600/p99.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-wvY8AIMBCo0/VfJxbUJs60I/AAAAAAAAAOc/RiyKJWAws60/s320/p99.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> step 5- select fact table drop down . click finish .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Now come to step 2 window select data source you created and click ok</span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
</div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://2.bp.blogspot.com/-yoWCWlSy8D4/VfJyMW6X0nI/AAAAAAAAAO8/IoNjvlJ0LGA/s1600/p11.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-yoWCWlSy8D4/VfJyMW6X0nI/AAAAAAAAAO8/IoNjvlJ0LGA/s320/p11.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;">Select first option and click ok . </span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://4.bp.blogspot.com/--CGUleWtlcE/VfJxlfd15aI/AAAAAAAAAOo/D4diPC9GizM/s1600/p910.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/--CGUleWtlcE/VfJxlfd15aI/AAAAAAAAAOo/D4diPC9GizM/s320/p910.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step7 drag and drop the fileds .</span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://4.bp.blogspot.com/-nizhD8CdKCw/VfJxzHcWiTI/AAAAAAAAAOs/ODpC3lpw4Yg/s1600/p12.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-nizhD8CdKCw/VfJxzHcWiTI/AAAAAAAAAOs/ODpC3lpw4Yg/s320/p12.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step8- select type of chart you want in report</span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://1.bp.blogspot.com/-_MQeIwbiHMM/VfJx6GscREI/AAAAAAAAAO0/mghUoOugJa4/s1600/p13.png" imageanchor="1" style="background-color: white; color: #2198a6; margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://1.bp.blogspot.com/-_MQeIwbiHMM/VfJx6GscREI/AAAAAAAAAO0/mghUoOugJa4/s320/p13.png" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step 9 - your report genrated .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">step10. save it .</span></span></div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-59789155256584818012016-07-19T01:14:00.004-07:002016-07-19T01:14:59.453-07:00How to Create DashBoard <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> How to create a dashboard in Pentaho .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 1. Log in to the pentaho server .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 2 . In home page go to create new -> dashboard - ></span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://4.bp.blogspot.com/-VmEtVTh3Ngo/VfgKkVRTDLI/AAAAAAAAAPM/WqeZjHvm8nE/s1600/p151.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-VmEtVTh3Ngo/VfgKkVRTDLI/AAAAAAAAAPM/WqeZjHvm8nE/s320/p151.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 3. select user the reports are saved .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://1.bp.blogspot.com/-hPCg2l0VJZI/VfgTfqS8kQI/AAAAAAAAAPg/1FCnywvZ5uM/s1600/p154.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-hPCg2l0VJZI/VfgTfqS8kQI/AAAAAAAAAPg/1FCnywvZ5uM/s320/p154.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
</div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 4 - Go to the file below and drag and drop the the charts in to the templets</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> you want to formate like . </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://4.bp.blogspot.com/--fqywiBJUi4/VfgKv_ZaWfI/AAAAAAAAAPY/VXusOwxPPl0/s1600/p152.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/--fqywiBJUi4/VfgKv_ZaWfI/AAAAAAAAAPY/VXusOwxPPl0/s320/p152.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 5 - change the tile of the each chart or file you drop below. templets.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<div class="separator" style="clear: both; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; text-align: center;">
<a href="http://1.bp.blogspot.com/-ZPPaBj8Exv8/VfgTxe_dwLI/AAAAAAAAAPo/goyOUEhU8Nk/s1600/p153.jpg" imageanchor="1" style="background-color: white; color: #2198a6; margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://1.bp.blogspot.com/-ZPPaBj8Exv8/VfgTxe_dwLI/AAAAAAAAAPo/goyOUEhU8Nk/s320/p153.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 6- Save the file . </span></div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-73099392069184333442016-07-19T01:12:00.001-07:002016-07-19T01:12:16.329-07:00How To Create Excel Report.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Setp1- Open Pentaho Report Designer .<br />
Step2- Create a new report .<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-y8YQaeNk2xE/VflN1j2BMdI/AAAAAAAAAP0/IEqXtIxSC2Q/s1600/p161.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://1.bp.blogspot.com/-y8YQaeNk2xE/VflN1j2BMdI/AAAAAAAAAP0/IEqXtIxSC2Q/s320/p161.jpg" width="320" /></a></div>
Step3- Click right click on the data select tables .<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-yCn50SpnEPY/VflOTeJoo3I/AAAAAAAAAP8/eOfG66e1fgQ/s1600/p162.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://2.bp.blogspot.com/-yCn50SpnEPY/VflOTeJoo3I/AAAAAAAAAP8/eOfG66e1fgQ/s320/p162.jpg" width="320" /></a></div>
Step4- Click + button to select the excel sheet .<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Step5- select the data sheet you want to create the report. Then click ok .It will display data on the window .<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/--_CQG26SMao/VflOeBiXloI/AAAAAAAAAQI/ChOXytqyBuo/s1600/p163.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://3.bp.blogspot.com/--_CQG26SMao/VflOeBiXloI/AAAAAAAAAQI/ChOXytqyBuo/s320/p163.jpg" width="320" /></a></div>
Step6- Drag and drop the fileds you want to create the report .<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-tg3aSWXMB2E/VflO3l27V7I/AAAAAAAAAQM/ll7B_wcPUPo/s1600/p165.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://4.bp.blogspot.com/-tg3aSWXMB2E/VflO3l27V7I/AAAAAAAAAQM/ll7B_wcPUPo/s320/p165.jpg" width="320" /></a></div>
<br />
Step7- Drag and drop chart icon then right click .<br />
Setp8- Select the fileld you want to create the chart . click ok<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-6r9UvSq-73Q/VflPDM_JTlI/AAAAAAAAAQU/55JbWM7Q9F4/s1600/p166.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://3.bp.blogspot.com/-6r9UvSq-73Q/VflPDM_JTlI/AAAAAAAAAQU/55JbWM7Q9F4/s320/p166.jpg" width="320" /></a></div>
Step9- Preview the report . It show the report.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-MVT9qKaRSTc/VflP7Y0sIiI/AAAAAAAAAQk/p6E6v6O6rZQ/s1600/p167.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://2.bp.blogspot.com/-MVT9qKaRSTc/VflP7Y0sIiI/AAAAAAAAAQk/p6E6v6O6rZQ/s320/p167.jpg" width="320" /></a></div>
<br />
Step 10- Go to file menu . Select Publish .<br />
Step11- Then select the server where you want publish the report give user name , password.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-M6FpzaRKGSs/VflQFrqQX-I/AAAAAAAAAQs/MEJJ5xJ7hQs/s1600/p169.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://3.bp.blogspot.com/-M6FpzaRKGSs/VflQFrqQX-I/AAAAAAAAAQs/MEJJ5xJ7hQs/s320/p169.jpg" width="320" /></a></div>
Step12 - Give Name and select forlder you want to publish the report.</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com1tag:blogger.com,1999:blog-973393426834082811.post-68547609589895572622016-07-19T01:06:00.001-07:002016-07-19T01:06:04.681-07:00Basic Of LDAP Server<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"> </span><br />
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Basics of the LDAP server .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> LDAP stands for Light Weight Directory Access Protocol . This help you access directories which is managed by the MS active directory or ApacheDS . Here we will discuss the basic of LDAP server.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step1- Go through this doc of LDAP server Setting .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><a href="http://docs.sitefinity.com/administration-configure-ldap-settings">http://docs.sitefinity.com/administration-configure-ldap-settings</a><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step2- Basic structure of the directory is here tree define the directory arrangement in</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> server.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 3 - The meanings of the code use in LDAP server.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> OU = Organisation Unit .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> CN = Common Names.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> uid=user id.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> DN= Domian Component.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Other Terms use in LDAP are .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> USERS - all users of the Domain</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Domain admins - Are the users who have every access.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Administrator - Administrator are also having all access and authority.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Groups - These are the people of particular types.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Remember a person can have membership of multiple groups. A can by user defined by multiple properties and membership of different groups. </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 4. To identify a particular type of user can understand by their membership and properties. </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 5:- The basics directory structure of LDAP server , Microsoft Active Directory or Apache AD and others are same. </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Further details on LDAP Integration you go through this video .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /> <a href="https://www.blogger.com/goog_2091086700"> </a></span><a href="https://www.youtube.com/watch?v=EN09e6ZH-ZA">https://www.youtube.com/watch?v=EN09e6ZH-ZA</a></div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-24955416750655561442016-07-19T00:19:00.003-07:002016-07-19T00:19:34.200-07:00How To Uninstall Pentaho<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"> <span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br />
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> How to uninstall Pentaho problematic -</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Some time we get problem to uninstall the pentaho BI from the system . so when you</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> get problem to uninstall the pentaho you can use following steps .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> 1 . First go the control panel then try to uninstall it . if uninstall successfully then ok .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> 2. If pentaho is installed but not showing in the list of software installed . Then</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> restart the system network safe mode . pressing F8 key . Go to control panel</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> then uninstall it.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> There are other ways are also available .. but this is convenient .</span></span><div>
<span style="background-color: #fb5e53; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"><br /></span></div>
</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-48197294131230057452016-07-19T00:18:00.003-07:002016-07-19T00:18:41.503-07:00BA Server UI Change Support.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"> <span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> If you want the UI change , logo change of home page or certain change in button</span></span><br />
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> link page . i hope it need JSP , html , tomcat server knowledge . Documents provided for</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> for this or available support is less .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Here is some supportive link to change the UI of home page etc.</span></span><div style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> 1 .To Change back ground image</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">biserver-ce/pentaho-solutions/system/common-ui/resources/themes/images/login-crystal-bg.jpeg</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> 2 .For the logo change</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> biserver-ce/pentaho-solutions/system/common-ui/resources/themes/images/puc-login-logo.png</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> 3. Home Page Content</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> biserver-ce/tomcat/webapps/pentaho/mantle/home/index.jsp - home page main content</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> 4. Upper menu of the home page--</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> biserver-ce/tomcat/webapps/pentaho/mantle/xul/mantle.xul</span></span></div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-23780101998293898112016-07-19T00:17:00.002-07:002016-07-19T00:17:35.321-07:00How To Create Geographical Report In Pentaho<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><br /></span>
<div class="post-header" style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 1.6; margin: 0px 0px 1.5em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-4604083970577848918" itemprop="description articleBody" style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px; width: 530px;">
<div dir="ltr" trbidi="on">
<h3 class="post-title entry-title" itemprop="name" style="color: #2198a6; font-family: Times, "Times New Roman", serif; font-size: 24px; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0px; position: relative;">
<br /></h3>
<span style="background-color: white;"><br /><br /><br /> For creating Geographical report on pentaho here is setp by step guide.<br /> <br /><br /><br /> Step 1- From Home page select analysis report .<br /><br /><br /> </span><div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-yygVwfT-dIU/VpiixN7kTZI/AAAAAAAAATQ/tRHBsL7UB3Q/s1600/G0.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-yygVwfT-dIU/VpiixN7kTZI/AAAAAAAAATQ/tRHBsL7UB3Q/s320/G0.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"> Step2 - Create an data source </span><div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-efgSWvn6dWE/Vpii1jR4vtI/AAAAAAAAAUA/AQyaLmxDn9Y/s1600/G2.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-efgSWvn6dWE/Vpii1jR4vtI/AAAAAAAAAUA/AQyaLmxDn9Y/s320/G2.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /> Step 3-- Name data source and select the table<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-cBbJjHf44-E/Vpii2aw3UCI/AAAAAAAAAUM/oi-HOKps3Zw/s1600/G3.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://3.bp.blogspot.com/-cBbJjHf44-E/Vpii2aw3UCI/AAAAAAAAAUM/oi-HOKps3Zw/s320/G3.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"> Step 4 -- If you not connected with your database then connect database and name<br /> the connection click edit connection .<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-V3jiabSoUIQ/Vpii3cLTC2I/AAAAAAAAAUU/58GvG4P_cUM/s1600/G4.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-V3jiabSoUIQ/Vpii3cLTC2I/AAAAAAAAAUU/58GvG4P_cUM/s320/G4.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br />Step 5--- Click next button on step 4 select the table and and drop down list .<br /><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-CXKnDlE7Jo4/Vpii4JTtD6I/AAAAAAAAAUg/on8s8r6NqPQ/s1600/G5.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-CXKnDlE7Jo4/Vpii4JTtD6I/AAAAAAAAAUg/on8s8r6NqPQ/s320/G5.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br />Step 6 - Click ok button for to create your data source.<br /><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-CeNci7MTER0/Vpii4txwy6I/AAAAAAAAAU8/ysAcr9LYrGY/s1600/G6.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-CeNci7MTER0/Vpii4txwy6I/AAAAAAAAAU8/ysAcr9LYrGY/s320/G6.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white;"><br /></span></div>
<span style="background-color: white;"> Step 7-- Select you data source and create click edit .<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-uSkdprzeb98/Vpii42-DlNI/AAAAAAAAAUk/0I85l0EgfwQ/s1600/G7.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://3.bp.blogspot.com/-uSkdprzeb98/Vpii42-DlNI/AAAAAAAAAUk/0I85l0EgfwQ/s320/G7.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br /> Step 8 -- Now you will get all fields of the table now what you need to do is create<br /> your own dimension you require .<br /><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-jl6LjdZMMHA/Vpii5VJUdoI/AAAAAAAAAU0/fXtMHfoBzHo/s1600/G8.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-jl6LjdZMMHA/Vpii5VJUdoI/AAAAAAAAAU0/fXtMHfoBzHo/s320/G8.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"> Step 9- Select your own filed here i am create country and city .<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-11g4W9SF4ec/VpijBBEbvCI/AAAAAAAAAVI/viGSK_oezfM/s1600/G9.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-11g4W9SF4ec/VpijBBEbvCI/AAAAAAAAAVI/viGSK_oezfM/s320/G9.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-E9eXKl_Ti24/VpiixEu33XI/AAAAAAAAATs/7kD2fuKSlFc/s1600/G10.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-E9eXKl_Ti24/VpiixEu33XI/AAAAAAAAATs/7kD2fuKSlFc/s320/G10.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-qZ9kqpuEzoM/Vpii5SyqJ6I/AAAAAAAAAUw/aPUGNo91SIc/s1600/G11.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-qZ9kqpuEzoM/Vpii5SyqJ6I/AAAAAAAAAUw/aPUGNo91SIc/s320/G11.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-9Fxs2nmt-Eg/VpiiyKGGpPI/AAAAAAAAATU/tqoHn8D0nrI/s1600/G12.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-9Fxs2nmt-Eg/VpiiyKGGpPI/AAAAAAAAATU/tqoHn8D0nrI/s320/G12.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br /> Step 10-- Create one measure like above step given by selecting table<br /> column and select drop down list .<br /><br /> <a href="http://3.bp.blogspot.com/-4voMBjiD7qk/Vpii1H6lLTI/AAAAAAAAAT4/-Ra6nxvwQ0M/s1600/G1country.jpg" imageanchor="1" style="color: #4d469c; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"><img border="0" height="200" src="https://3.bp.blogspot.com/-4voMBjiD7qk/Vpii1H6lLTI/AAAAAAAAAT4/-Ra6nxvwQ0M/s320/G1country.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a><br /><br /> Step 11- Select the measurement column form the table .<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-wDkP-PRcYxo/Vpiiy29KASI/AAAAAAAAATc/-BS3GInhXL0/s1600/G13.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://1.bp.blogspot.com/-wDkP-PRcYxo/Vpiiy29KASI/AAAAAAAAATc/-BS3GInhXL0/s320/G13.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-DFZ72gh88yQ/VpiizoAFy0I/AAAAAAAAATk/-dEAnI6B1WE/s1600/G14.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-DFZ72gh88yQ/VpiizoAFy0I/AAAAAAAAATk/-dEAnI6B1WE/s320/G14.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br /> Step 12 - Go to step 1 and select datasource you created . and select<br /> geo report from the drop down.<br /><br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-fj7tXb0Se78/Vpii0XihIAI/AAAAAAAAATw/JcmWE8XlahM/s1600/G15.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://4.bp.blogspot.com/-fj7tXb0Se78/Vpii0XihIAI/AAAAAAAAATw/JcmWE8XlahM/s320/G15.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /> Step 13 - Complete your steps selecting measure drop down .</span><div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-w_D7pip1Dmo/Vpii0iwJ4oI/AAAAAAAAAUY/C2VvfTpy68k/s1600/G16.jpg" imageanchor="1" style="background-color: white; color: #4d469c; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="200" src="https://2.bp.blogspot.com/-w_D7pip1Dmo/Vpii0iwJ4oI/AAAAAAAAAUY/C2VvfTpy68k/s320/G16.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
<span style="background-color: white;"><br /><br /> Step 14 - So here is your report with load default 250 record or if you want go<br /> setting and increase the number of record.<br /></span><div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-6gqmjG2ikE0/Vpii6dJmgUI/AAAAAAAAAU4/Sb9YMpXMF5s/s1600/GF.jpg" imageanchor="1" style="background-color: white; color: #2198a6; margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://4.bp.blogspot.com/-6gqmjG2ikE0/Vpii6dJmgUI/AAAAAAAAAU4/Sb9YMpXMF5s/s320/GF.jpg" style="border: none; padding: 8px; position: relative;" width="320" /></a></div>
</div>
</div>
</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-12687590509408302052016-07-19T00:16:00.000-07:002016-07-19T00:16:00.699-07:00Integrate Pentaho With LDAP Server.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<br />
<br />
<br />
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> How to integrate pentaho with the LDAP server.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 1 - Run entaho server log it . At home menu click - > administration -> select use LDAP or Active Directory.</span></span><div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 2 - Provide the server URL , authorized admin user and password.</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 3- Provide a domian user and role . A domain user is user who have authority</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> to all access of LDAP server. So selecting the user insure the all authority.</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 4- Provide the role of the user you selected that means domain admin . if you are using</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> active directory then configration will be like this .</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 5 - Provide the serach base for the user . Which is parent directory of the selected user.</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 6- If you are using microsoft active directory . Then search will be like (sAMAccountName={0}).</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 7- Role attribute for the global search can be configure like this.</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Role search - (objectCategory=*)</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Role Search base will be parent directory of the role search .</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 8- Role attribute will be</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> role attribute - cn</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> group -CN=Users,DC=COELAB,DC=COM</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> filter - (member={0})</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 9 - You can test you connection .</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> Step 10 - Test connection for LDAP configuration .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 11 - Test connection for role .</span></span></div>
<div>
<span style="background-color: white;"><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;">Step 12 Test connection for Popular .</span><br style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><span style="color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;"> </span></span><br style="background-color: #fb5e53; color: #666666; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.2px;" /><br /></div>
</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0tag:blogger.com,1999:blog-973393426834082811.post-37670886811799952432016-07-19T00:13:00.000-07:002016-07-19T00:13:15.103-07:00Pentaho Database Connection Jar<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="p" style="background-color: white; font-family: "Open Sans", arial, helvetica, sans-serif; font-size: 14.4px; line-height: 22.32px; margin-top: 20px;">
<br /></div>
<div class="p" style="background-color: white; font-family: "Open Sans", arial, helvetica, sans-serif; font-size: 14.4px; line-height: 22.32px; margin-top: 20px;">
This blog gives link to download jar file and location to copy of the jar file in to the pentaho server.</div>
<div class="p" style="background-color: white; font-family: "Open Sans", arial, helvetica, sans-serif; font-size: 14.4px; line-height: 22.32px; margin-top: 20px;">
<br /></div>
<div class="p" style="background-color: white; font-family: "Open Sans", arial, helvetica, sans-serif; font-size: 14.4px; line-height: 22.32px; margin-top: 20px;">
The BA and DI Servers need the appropriate driver to connect to the database that stores your data. You can download drivers from your database vendor's website. A JDBC Drivers reference article, with links to the corresponding websites, can be found <a class="xref" href="http://help.pentaho.com/Documentation/5.4/0D0/160/010" rel="internal" style="background-color: transparent; color: #005da6; text-decoration: none;" title="Documentation/5.1/160/010">here</a>. To install your driver:</div>
<div class="p" style="background-color: white;">
<ol class="ol" id="6e93e158-9c6a-4c50-b58b-01cd562a3540__troubleshooting_jdbc_java__ol_jyq_xkb_5m" style="font-family: "Open Sans", arial, helvetica, sans-serif; font-size: 14.4px; line-height: 1.4; margin-bottom: 0px; margin-top: 20px; padding-left: 1.4em;">
<li class="li" style="line-height: 22.32px; margin: 0.25em 0px;">Stop the BA Server.</li>
<li class="li" style="line-height: 22.32px; margin: 0.25em 0px;">Copy your driver into this location: <code class="ph codeph" style="color: #666666; display: inline-block; font-family: "Source Code Pro", monospace; font-size: 14.4px; font-stretch: normal; line-height: 1.4; margin: 0px; padding: 0px;"><pentaho-install-directory>/server/biserver-ee/tomcat/lib</code>.</li>
<li class="li" style="line-height: 22.32px; margin: 0.25em 0px;">Start the BA Server.</li>
<li class="li" style="line-height: 22.32px; margin: 0.25em 0px;">For BI Server folder location will be /tomcat/lib .</li>
</ol>
<div>
<span style="font-family: Open Sans, arial, helvetica, sans-serif;"><span style="font-size: 14.4px; line-height: 22.32px;"><br /></span></span></div>
<div>
<span style="font-family: Open Sans, arial, helvetica, sans-serif;"><span style="font-size: 14.4px; line-height: 22.32px;"> These are drivers given for different database. </span></span></div>
<div>
<span style="font-family: Open Sans, arial, helvetica, sans-serif;"><span style="font-size: 14.4px; line-height: 22.32px;"><a href="http://help.pentaho.com/Documentation/6.0/0D0/160/010">http://help.pentaho.com/Documentation/6.0/0D0/160/010</a></span></span></div>
<div style="font-family: "Open Sans", arial, helvetica, sans-serif; font-size: 14.4px;">
<span style="line-height: 22.32px;"><br /></span></div>
</div>
</div>
Mukesh Jhahttp://www.blogger.com/profile/09557084889809094253noreply@blogger.com0