tag:blogger.com,1999:blog-83806981461529750192024-03-10T04:46:37.853+02:00Business Intelligence for everyoneyoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.comBlogger292125tag:blogger.com,1999:blog-8380698146152975019.post-19405234810673318382014-08-31T11:39:00.002+03:002014-08-31T11:39:25.018+03:00<div dir="rtl" style="text-align: right;" trbidi="on">
<div style="direction: ltr; text-align: left;">
Hi everyone,</div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div style="direction: ltr; text-align: left;">
After almost half a year of preparations and writing ,my new book :SAP BusinessObjects Reporting Cookbook is published ,it is dealing with the main BI tool of the SAP BI4 platform- Web Intelligence ,covering it from A-Z and based on my working experience and how to use and implement best practices,hope you enjoy reading it,</div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div style="direction: ltr; text-align: left;">
Yoav Yahav</div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div style="direction: ltr; text-align: left;">
<a href="https://www.packtpub.com/big-data-and-business-intelligence/sap-businessobjects-reporting-cookbook" target="_blank">SAP BusinessObjects Reporting Cookbook</a></div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBNPEvCU3Hp35euFDhTaA_iaFfIQa80YUvg6IHAWXD5ovxbXSxGR-epq55CitIcH3FK3ENXxY6QtUMlCqjoiRGM1RZl8m6tVhc7VelL4ef9o4V1GYGJXQ6MUAcCkdj07uQQ0j-gXjdiIM/s1600/2437EN_cov.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBNPEvCU3Hp35euFDhTaA_iaFfIQa80YUvg6IHAWXD5ovxbXSxGR-epq55CitIcH3FK3ENXxY6QtUMlCqjoiRGM1RZl8m6tVhc7VelL4ef9o4V1GYGJXQ6MUAcCkdj07uQQ0j-gXjdiIM/s1600/2437EN_cov.jpg" height="400" width="323" /></a></div>
<div style="direction: ltr; text-align: left;">
<br /></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-63568257342711981462014-06-10T17:30:00.002+03:002014-06-10T17:30:54.033+03:00What’s New in SAP HANA SPS 08<div dir="rtl" style="text-align: right;" trbidi="on">
<div style="direction: ltr; text-align: justify;">
Read here about all the new latest changes in the last version of HANA:</div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
<div style="direction: ltr; text-align: justify;">
<a href="http://www.saphana.com/community/blogs/blog/2014/05/28/what-s-new-in-sap-hana-sps-08">http://www.saphana.com/community/blogs/blog/2014/05/28/what-s-new-in-sap-hana-sps-08</a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-41802049641410471192014-06-10T17:28:00.000+03:002014-06-10T17:28:10.369+03:00Power BI Connectivity to SAP BusinessObjects BI Now Generally Available<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="rtl" style="text-align: right;" trbidi="on">
<div style="text-align: left;">
<div style="direction: ltr;">
</div>
<div style="direction: ltr;">
<br /></div>
<div dir="rtl" style="text-align: right;" trbidi="on">
<div>
<div dir="ltr" style="text-align: left;">
<span style="background-color: white; color: #999999; font-family: 'Segoe UI', wf_segoe-ui_normal, Helvetica, Arial, sans-serif; font-size: 18px; text-align: start;">Microsoft and SAP announced the general availability of Power BI connectivity to SAP BusinessObjects BI. This joint business intelligence interoperability solution is delivered in Microsoft Excel, </span><a href="http://www.microsoft.com/en-us/powerbi/default.aspx?WT.mc_id=Blog_PBI_Announce_DI" style="background-color: white; color: #0044cc; font-family: 'Segoe UI', wf_segoe-ui_normal, Helvetica, Arial, sans-serif; font-size: 18px; text-align: start; text-decoration: none;">Power BI for Office 365</a><span style="background-color: white; color: #999999; font-family: 'Segoe UI', wf_segoe-ui_normal, Helvetica, Arial, sans-serif; font-size: 18px; text-align: start;">, and SAP BusinessObjects BI. With this </span><a href="http://www.microsoft.com/en-us/powerBI/SAP.aspx?WT.mc_id=Blog_PBI_Announce_DI" style="background-color: white; color: #0044cc; font-family: 'Segoe UI', wf_segoe-ui_normal, Helvetica, Arial, sans-serif; font-size: 18px; text-align: start; text-decoration: none;">solution</a><span style="background-color: white; color: #999999; font-family: 'Segoe UI', wf_segoe-ui_normal, Helvetica, Arial, sans-serif; font-size: 18px; text-align: start;">, users can....<a href="http://www.microsoft.com/en-us/powerBI/bi-blog.aspx#fbid=qX8k6NHhYkM">click here for further reading</a>...<a href="https://www.blogger.com/"></a></span></div>
</div>
<div style="text-align: center;">
<br /></div>
<div>
<br /></div>
</div>
<div dir="ltr" style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="305" src="https://www.youtube.com/embed/Ay-J0ddBpRk" width="500"></iframe> </div>
</div>
</div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-16724455774582406232014-03-18T21:16:00.000+02:002014-03-19T13:00:04.710+02:00SAP BusinessObjects Reporting Cookbook coming up<div dir="rtl" style="text-align: right;" trbidi="on">
<div style="direction: ltr; text-align: justify;">
Hi All,</div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
<div style="direction: ltr; text-align: justify;">
Been very busy in the last months writing the <b>SAP BusinessObjects Reporting Cookbook</b> for packet publishing an A-Z guide that will walk you through the entire Web Intelligence environement,the book isn't yet ready and would be in the stores in <b>October 2014</b> but you can already get the preview or the RAW version of it ,enjoy..more updates will come soon </div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="direction: ltr; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://ecx.images-amazon.com/images/I/51gOUkdN9DL._AA160_.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://ecx.images-amazon.com/images/I/51gOUkdN9DL._AA160_.jpg" /></a></div>
<br /></div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
<div style="direction: ltr; text-align: justify;">
<a href="http://www.packtpub.com/sap-businessobjects-reporting-cookbook/book">SAP BusinessObjects Reporting Cookbook</a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-52800502117666251382013-09-11T15:57:00.000+03:002013-09-20T14:17:15.321+03:00Creating default value in a dynamic date range prompt<div dir="rtl" style="text-align: right;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
One of the most requested features in Web Intelligence reports is to have a default value in a time range prompt that will enable to chose time frames such as current day, last day and ctr.<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
In the following example I will demonstrate how to implement such logic in a very simple way<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
I am using:<br />
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="direction: ltr; text-align: left; text-indent: -0.25in;">
<ul style="text-align: left;">
<li><span style="text-indent: -0.25in;"><span style="font-family: 'Times New Roman';"> <b> </b></span><span style="font-family: Times, Times New Roman, serif;"><b> BI4 SP6</b></span></span></li>
<li><span style="font-family: Times, Times New Roman, serif; text-indent: -0.25in;"><b> Oracle 11</b></span></li>
<li><span style="font-family: Times, Times New Roman, serif; text-indent: -0.25in;"><b> A Custom Universe containing a time view table</b></span></li>
<li><span style="font-family: Times, Times New Roman, serif; text-indent: -0.25in;"><b> Information design tool</b></span></li>
</ul>
</div>
<br />
<o:p></o:p>
<br />
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<ol style="text-align: left;">
<li><span style="text-indent: -0.25in;">First we will create s special super prompt condition object that will enable us to choose date range ,current month or last month :</span></li>
</ol>
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7hy2Ym5Kn_2NXcBA9rx7LUPzG30ZQkrUQ1LAJmyxQs8gKaC83ZpePT6HkfIPTE9eXinD0zrpXjwg2-1kpVfxXXO7Palx5KfRmdhzd_fALLYhuSXNGOKrTlsw_yxaMxyfHC9LtlJdzLOs/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7hy2Ym5Kn_2NXcBA9rx7LUPzG30ZQkrUQ1LAJmyxQs8gKaC83ZpePT6HkfIPTE9eXinD0zrpXjwg2-1kpVfxXXO7Palx5KfRmdhzd_fALLYhuSXNGOKrTlsw_yxaMxyfHC9LtlJdzLOs/s1600/1.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
This script uses a case when phrase that allows choosing
several time ranges.<o:p></o:p><br />
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
For example ‘<span style="font-family: 'Segoe UI', sans-serif; font-size: 9pt; line-height: 115%;">this month</span>’ will return
the function: TRUNC(SYSDATE,'MM') which will result us the current month data<o:p></o:p><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5vopie0bsKgjYLoU4ki3ONZZxzlRFIjBTK2CPiXP7yTH0fhyYJbz9mJxRvMzoYOJDYw35K8I3iN_oROtV20K4sKiD1x4BKZwDOpKMIrvhz3XMkaLsiEzFJ_5glwRsdZpD2hxdB7m5x9Y/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5vopie0bsKgjYLoU4ki3ONZZxzlRFIjBTK2CPiXP7yTH0fhyYJbz9mJxRvMzoYOJDYw35K8I3iN_oROtV20K4sKiD1x4BKZwDOpKMIrvhz3XMkaLsiEzFJ_5glwRsdZpD2hxdB7m5x9Y/s1600/2.png" /></a></div>
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
</div>
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>
<div style="direction: ltr;">
<br /></div>
<div style="direction: ltr; text-align: justify;">
<span style="text-align: left;"><b>Here is the full syntax:</b></span></div>
<div style="direction: ltr; text-align: justify;">
<b><o:p></o:p></b></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<b><o:p></o:p></b></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">"GenericDateTable".GENERICCURRENTDATE between<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">Case
WHEN @Prompt('From
Date(dd/mm/yyyy)','A',,Mono,Free,Not_Persistent)='last month' then
trunc(add_months(last_day(sysdate),-2)) + 1<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">WHEN @Prompt('From
Date(dd/mm/yyyy)','A',,Mono,Free,Not_Persistent)='this month' then TRUNC(SYSDATE,'MM')<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">Else To_Date(@Prompt('From
Date(dd/mm/yyyy)','A',,Mono,Free,Not_Persistent),'DD/MM/YYYY')<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;"> End<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">AND <o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">Case when @Prompt('To Date
(dd/mm/yyyy)','A',,Mono,Free,Not_Persistent) = 'last month' THEN trunc(add_months(last_day(sysdate),-1))<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">WHEN @Prompt('From Date(dd/mm/yyyy)','A',,Mono,Free,Not_Persistent)='this
month' then ADD_MONTHS(TRUNC(SYSDATE,'MM'),+1) <o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;">Else
To_DATE(@Prompt('To Date
(dd/mm/yyyy)','A',,Mono,Free,Not_Persistent),'DD/MM/YYYY')<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%;"> End </span><br />
<span style="text-indent: -0.25in;"><br /></span><span style="text-indent: -0.25in;"><br /></span>
<br />
<div style="text-indent: 0px;">
<span style="text-indent: -0.25in;"><span style="font-size: x-small;"><span style="line-height: 14px;">2. </span></span>Now we will first test our prompt to varify that it is working currectly :</span><br />
<span style="text-indent: -0.25in;"><br /></span></div>
</div>
<div class="MsoListParagraph" style="direction: ltr; text-align: left; text-indent: -0.25in;">
<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<b>This month data :</b><o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieZCWVABUqsH6NzwuUZwPdRTv0JRLFDS7N0OPpC_OFCnmeTRtgnD6VBttVhOkRAdAKsPVZjyd497fUoLFDGafOAW67NR_SDizBgxxeGYd920XS8PlYjZGtL7FDthhu6QW-9UvR6A8iOMQ/s1600/This_Month.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieZCWVABUqsH6NzwuUZwPdRTv0JRLFDS7N0OPpC_OFCnmeTRtgnD6VBttVhOkRAdAKsPVZjyd497fUoLFDGafOAW67NR_SDizBgxxeGYd920XS8PlYjZGtL7FDthhu6QW-9UvR6A8iOMQ/s1600/This_Month.png" /></a></div>
<br />
<div>
<br /></div>
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVPPxr0SQs2F6QUfD8YyiZR9PJpSZSCoNjIIeKHXRtGYPCf7ZnNVWkbM0D-F4NKCYoJ6xKSNON-2ZWKkzQigPDp6D76YL41pAnAZmfeCdh2OBH_ICLJjocepAqL9QJJL3Of1llM_GVghA/s1600/This)month_data.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVPPxr0SQs2F6QUfD8YyiZR9PJpSZSCoNjIIeKHXRtGYPCf7ZnNVWkbM0D-F4NKCYoJ6xKSNON-2ZWKkzQigPDp6D76YL41pAnAZmfeCdh2OBH_ICLJjocepAqL9QJJL3Of1llM_GVghA/s1600/This)month_data.png" /></a></div>
<div style="direction: ltr; text-align: center;">
<br /></div>
<br />
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
</div>
</div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<o:p><b>Last month data :</b></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdEFEny87vmpZGyxVIPMEgx9d-jO0CFFi-m9pq-g9E3VhXjV6QIjUbUgKnoHiXgMePq1s28sHr8ALya19avCFqIffW5c_jKps5Ze2HlrOUya_JBbNpIlyUElWfp-QWGwRmwVlmKybucHY/s1600/Last_month.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdEFEny87vmpZGyxVIPMEgx9d-jO0CFFi-m9pq-g9E3VhXjV6QIjUbUgKnoHiXgMePq1s28sHr8ALya19avCFqIffW5c_jKps5Ze2HlrOUya_JBbNpIlyUElWfp-QWGwRmwVlmKybucHY/s1600/Last_month.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdZyo3lmtmOq9SUDWW24sGH7zE_4dddG0okbREmZDWyBx9LNzWVIEHtelUhKZIoHYpKCvgLO0Z6BMFREC21yUsorvEUrGQTmAb1xC9gTZvogKeVspgMKWmVWqDWNWaR8SR7GBBWdRxSlw/s1600/last_month_data.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdZyo3lmtmOq9SUDWW24sGH7zE_4dddG0okbREmZDWyBx9LNzWVIEHtelUhKZIoHYpKCvgLO0Z6BMFREC21yUsorvEUrGQTmAb1xC9gTZvogKeVspgMKWmVWqDWNWaR8SR7GBBWdRxSlw/s1600/last_month_data.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div>
<div style="text-align: justify;">
<b style="text-align: left;"><br /></b></div>
<div style="direction: ltr; text-align: justify;">
<b style="text-align: left;">Date range :</b></div>
</div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<div style="text-align: right;">
<br /></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj31sQO0mkxwk0P-szUW9uJuNYGMqEglrLK8_EvJ8p8C90UyFsXDnH2iwPq0zwNWh17a5cZq1qVll3yNkah7IG9vUe-ztRqMnla3QTMMMmuU_FBAopuAD16e6RxEg4YtJQXv6TRjiDls9U/s1600/date_range.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj31sQO0mkxwk0P-szUW9uJuNYGMqEglrLK8_EvJ8p8C90UyFsXDnH2iwPq0zwNWh17a5cZq1qVll3yNkah7IG9vUe-ztRqMnla3QTMMMmuU_FBAopuAD16e6RxEg4YtJQXv6TRjiDls9U/s1600/date_range.png" /></a></div>
<br />
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQXVMewCTaoNVv1sS-VWUkvOH8YV5tnVlJiFapAoMNe6q1bKHqsnSv0zvMHiY6x4x6FmuLS06iumzwuZSDeSSDcBVzZRvQFzgOMsPQg97onU6XgM1vLnBYT7AsHJCKvmPgi5qGviVbpNM/s1600/8.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><br /></a><o:p style="text-align: left;"></o:p>
<br />
<div style="direction: ltr; text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB106dHYk1I8XBy3wcnnt14-U037dE2gZcL0uy0yparrctJCdiYxtQYVqKAt7dbjgZcC5MddfeyBL2tRjjpd6D69OtT1oreiO3LkmfTEmgFOC4V0maAntTjfgqpjBMHxQ6Xxz_9Ij8lIc/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB106dHYk1I8XBy3wcnnt14-U037dE2gZcL0uy0yparrctJCdiYxtQYVqKAt7dbjgZcC5MddfeyBL2tRjjpd6D69OtT1oreiO3LkmfTEmgFOC4V0maAntTjfgqpjBMHxQ6Xxz_9Ij8lIc/s1600/8.png" /></a></div>
<o:p><br /></o:p></div>
<div style="direction: ltr; text-align: left;">
<br /></div>
<div style="direction: ltr; text-align: left;">
<o:p> </o:p><span style="text-indent: -0.25in;">3.Now we will add a sinple parameter to the prompt syntac which will allow us to use a default value </span></div>
<div style="direction: ltr; text-align: left;">
<span style="text-indent: -0.25in;">that </span><span style="text-indent: -0.25in;">corresponed to our prompt ,lets use the value ‘last month’,t</span><span style="text-indent: -0.25in;">he last parameter in the prompt is the one that holds the default value and as you can see when we open the report the default value is already there :</span><br />
<span style="text-indent: -0.25in;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggcaNXsP6IGCr2wkV-Ug-ANUd93o2bcenZvUbfgEEwXxbDT51fHwz2m6Yee5TRxDPmIOTJ_gouMTpPBJs3qmUEEJoYmP9QUGJLljM4pReR6YnrzBeUvptsKMxAlIq7zO3cLvDpQQbV4ZM/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggcaNXsP6IGCr2wkV-Ug-ANUd93o2bcenZvUbfgEEwXxbDT51fHwz2m6Yee5TRxDPmIOTJ_gouMTpPBJs3qmUEEJoYmP9QUGJLljM4pReR6YnrzBeUvptsKMxAlIq7zO3cLvDpQQbV4ZM/s1600/9.png" /></a></div>
<span style="text-indent: -0.25in;"><br /></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="MsoListParagraph" style="direction: ltr; text-align: left; text-indent: -0.25in;">
<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">"GenericDateTable".GENERICCURRENTDATE between<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">Case WHEN @Prompt('From
Date(dd/mm/yyyy)','A',,mono,free,Not_Persistent<b>,<span style="background-color: yellow;">{'last month'})</span>=</b>'last
month' then trunc(add_months(last_day(sysdate),-2)) + 1<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">WHEN @Prompt('From
Date(dd/mm/yyyy)','A',,mono,free,Not_Persistent,<span style="background-color: yellow;">{'last month'}</span>)='this month'
then TRUNC(SYSDATE,'MM')<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">Else To_Date(@Prompt('From
Date(dd/mm/yyyy)','A',,mono,free,Not_Persistent,<span style="background-color: yellow;">{'last month'}</span>),'DD/MM/YYYY')<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"> End<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">AND <o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">Case when @Prompt('To Date
(dd/mm/yyyy)','A',,mono,free,Not_Persistent,<span style="background-color: yellow;">{'last month'}</span>) = 'last month'
THEN
trunc(add_months(last_day(sysdate),-1))<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">WHEN @Prompt('From
Date(dd/mm/yyyy)','A',,mono,free,Not_Persistent,<span style="background-color: yellow;">{'last month'}</span>)='this month'
then ADD_MONTHS(TRUNC(SYSDATE,'MM'),+1) <o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">Else To_DATE(@Prompt('To Date
(dd/mm/yyyy)','A',,mono,free,Not_Persistent,<span style="background-color: yellow;">{'last month'}</span>),'DD/MM/YYYY')<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<span style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"> End <o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br />
Now when we will run the report we will see the default value:<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="MsoNormal" style="direction: ltr; text-align: left;">
And that’s it….<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
Conclusion:<o:p></o:p></div>
<div class="MsoNormal" style="direction: ltr; text-align: left;">
<br /></div>
<br />
<div class="MsoNormal" style="direction: ltr; text-align: left;">
Implementing default dynamic time range is simple but can be
also used to reports that are required to run daily using date range but also
required to be scheduled on last month, by implementing such prompt we will
reduce the number of versions of the same report: one version for daily running
and the other version for scheduling…<o:p></o:p></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-23462096562865345772013-07-08T12:21:00.000+03:002013-07-08T12:28:06.727+03:00Web Intelligence 4.1, what's new?<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Official presentation by <span style="background-color: white; color: #8b8b8b; font-family: arial, helvetica, sans-serif; font-size: 11px; line-height: 10.796875px;"> </span><a class="jiveTT-hover-user jive-username-link" data-avatarid="-1" data-externalid="" data-presence="null" data-userid="13494" data-username="gregory.botticchio" href="http://scn.sap.com/people/gregory.botticchio" id="jive-1349427734961064528374" style="background-color: white; border: 0px; color: #8ca9cd; font-family: arial, helvetica, sans-serif; font-size: 11px; line-height: 10.796875px; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">Gregory Botticchio</a><span style="background-color: white; color: #8b8b8b; font-family: arial, helvetica, sans-serif; font-size: 11px; line-height: 10.796875px;"> </span><img src="http://scn.sap.com/themes/sap-scn/images/icon_sap.png" style="background-color: white; border: 0px; color: #8b8b8b; font-family: arial, helvetica, sans-serif; font-size: 11px; line-height: 10.796875px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;" /> :<br />
<br />
<a href="http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0298826-1ec5-3010-c892-9e92a4574404?QuickLink=index&overridelayout=true&58540404247860">http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0298826-1ec5-3010-c892-9e92a4574404?QuickLink=index&overridelayout=true&58540404247860</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVAzGwb3pwek1lUylK5DFUU5xEKj3S9cRX7Kz6_YnrEmGgR8OVsPDK6o6JmZTK5-ADU9d_Jjuy-iKXBmbDC424RFfamlZD06bj-jRBG3sAGMHwNvj_ZiGQXNKkXZks1RUcROL8jt7srdA/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVAzGwb3pwek1lUylK5DFUU5xEKj3S9cRX7Kz6_YnrEmGgR8OVsPDK6o6JmZTK5-ADU9d_Jjuy-iKXBmbDC424RFfamlZD06bj-jRBG3sAGMHwNvj_ZiGQXNKkXZks1RUcROL8jt7srdA/s320/1.jpg" width="250" /></a></div>
<br /></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-53673096977610991742013-07-01T16:08:00.000+03:002013-07-01T16:10:51.092+03:00Asug 2013 session :Strategies for Selecting the Right BI Client Product Based on Your Own Requirements<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<a href="http://events.asug.com/2013AC/Business%20Intelligence/0507%20Strategies%20for%20Selecting%20the%20Right%20BI%20Client%20Product.pdf">http://events.asug.com/2013AC/Business%20Intelligence/0507%20Strategies%20for%20Selecting%20the%20Right%20BI%20Client%20Product.pdf</a></div>
<div dir="ltr" style="text-align: left;">
<span style="color: #0000ee;"><u><br /></u></span><a href="http://events.asug.com/2013AC/Business%20Intelligence/0507%20Strategies%20for%20Selecting%20the%20Right%20BI%20Client%20Product.pdf"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1wJUxcVOLItR7gPFbd43ln5RyUat8M76-xaB6R6mUPaCkHnQT3YML_7hrFjMK5i9oGZ9JahLEy3rYMh85fDi5IUvfO3uABDY_UXpuZiM2Qka2ayX_3Cx5tupLjhRNQAuutqQkgW_uLsY/s768/Untitled.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="255" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1wJUxcVOLItR7gPFbd43ln5RyUat8M76-xaB6R6mUPaCkHnQT3YML_7hrFjMK5i9oGZ9JahLEy3rYMh85fDi5IUvfO3uABDY_UXpuZiM2Qka2ayX_3Cx5tupLjhRNQAuutqQkgW_uLsY/s320/Untitled.jpg" width="320" /></a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-46513359509130988482013-06-26T13:34:00.000+03:002013-06-26T13:37:48.168+03:00Mobile Minute: Preview of Analytics on the SAP HANA Cloud from the iPad<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<iframe allowfullscreen="" frameborder="0" height="360" src="http://www.youtube.com/embed/ePNue37C77A?feature=player_detailpage" width="540"></iframe></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-57127799076130072242013-06-24T10:04:00.000+03:002013-06-24T10:05:11.865+03:00SAP HANA: Overview - Use HANA with BI 4.0 Service Pack 4 <div dir="rtl" style="text-align: right;" trbidi="on">
<br />
<br />
<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/rtqf7OmhnlI?feature=player_detailpage" width="550"></iframe><br />
<br />
<br />
<br />
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-20492587629290154132013-06-24T09:57:00.001+03:002013-06-24T09:57:29.154+03:00What is new in Mobile BI 5.0 ?<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
Read about all the new exiting chnages in the latest version of Mobile BI :</div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<a href="http://scn.sap.com/community/mobile/businessobjects/blog/2013/06/20/what-is-new-in-mobile-bi-50-asug-webcast-part-1">http://scn.sap.com/community/mobile/businessobjects/blog/2013/06/20/what-is-new-in-mobile-bi-50-asug-webcast-part-1</a></div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<a href="http://scn.sap.com/community/mobile/businessobjects/blog/2013/06/20/what-is-new-in-mobile-bi-50-part-2-asug-webcast">http://scn.sap.com/community/mobile/businessobjects/blog/2013/06/20/what-is-new-in-mobile-bi-50-part-2-asug-webcast</a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-16210677936289610452013-05-20T15:28:00.000+03:002013-05-20T15:52:02.754+03:00SAP BusinessObjects BI 4.1 Release to Customers<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
Just before the SAPPHIRE NOW conference, SAP announced the Release to Customer (RTC) of SAP BusinessObjects BI 4.1, Edge BI 4.1 and Crystal Server 2013.</div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
Read here about all the new features in this version:</div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<a href="http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_whats_new_en.pdf">http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_whats_new_en.pdf</a></div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div dir="ltr" style="text-align: left;">
<a href="http://assets.timoelliott.com/docs/SAP%20BusinessObjects%20BI%204.1%20What's%20New%20L2.pdf">http://assets.timoelliott.com/docs/SAP%20BusinessObjects%20BI%204.1%20What's%20New%20L2.pdf</a></div>
<div dir="ltr" style="text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://timoelliott.com/blog/wp-content/uploads/2013/05/strategic-focus_thumb.jpg" imageanchor="1" style="height: 160px; margin-left: 1em; margin-right: 1em; width: 304px;"><img border="0" height="160" src="http://timoelliott.com/blog/wp-content/uploads/2013/05/strategic-focus_thumb.jpg" width="320" ya="true" /></a></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://timoelliott.com/blog/wp-content/uploads/2013/05/one-information.jpg" imageanchor="1" style="height: 208px; margin-left: 1em; margin-right: 1em; width: 308px;"><img border="0" height="208" src="http://timoelliott.com/blog/wp-content/uploads/2013/05/one-information.jpg" width="320" ya="true" /></a></div>
<br /></div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-86042241358538278802013-03-06T11:47:00.002+02:002013-03-06T11:47:29.041+02:00SAP Offers Small Businesses More Visibility and Control With Business Management Solution Running Fully on SAP HANA Platform<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
SAP today announced SAP Business One, version for SAP HANA, the first business management solution for SMEs running fully in memory:</div>
<div dir="ltr" style="text-align: left;">
</div>
<div dir="ltr" style="text-align: left;">
</div>
<div dir="ltr" style="text-align: left;">
<a href="http://www.news-sap.com/sap-offers-small-businesses-more-visibility-and-control-with-business-management-solution-running-fully-on-sap-hana-platform/">http://www.news-sap.com/sap-offers-small-businesses-more-visibility-and-control-with-business-management-solution-running-fully-on-sap-hana-platform/</a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-55859391669882120972013-01-14T08:58:00.001+02:002013-01-14T08:58:13.057+02:00Lifecycle Manager Overrides in BI4 <div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
A good article I read today explaining the difficulties using promotion management</div>
<div dir="ltr" style="text-align: left;">
<br /> (former known as life cycle management ) in BI4 platform : </div>
<div dir="ltr" style="text-align: left;">
<br /><a href="http://davidlai101.com/blog/2012/12/25/demystifying-lcm-overrides/">http://davidlai101.com/blog/2012/12/25/demystifying-lcm-overrides/</a></div>
<div dir="ltr" style="text-align: left;">
</div>
<div dir="ltr" style="text-align: left;">
you can also read here a in general but the bugs aren't mentioned :</div>
<div dir="ltr" style="text-align: left;">
</div>
<div dir="ltr" style="text-align: left;">
<a href="http://wiki.sdn.sap.com/wiki/display/BOBJ/Lifecycle+Manager+Overrides+in+BI4">http://wiki.sdn.sap.com/wiki/display/BOBJ/Lifecycle+Manager+Overrides+in+BI4</a><br /> </div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-54914024909175657612013-01-14T08:45:00.001+02:002013-01-14T08:45:09.174+02:00How SAP BW and HANA will merge over time -- and why it matters <div dir="rtl" style="text-align: right;" trbidi="on">
<div style="text-align: left;">
<strong>Read the </strong><a href="http://searchsap.techtarget.com/feature/HANA-or-Business-Warehouse-Choice-depends-on-SAP-data-management-needs"><strong>first of this two-part series</strong></a><strong> on SAP Business Warehouse and HANA. Part one addresses how companies should consider their data management needs when assessing the technologies.</strong></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<a href="http://searchsap.techtarget.com/feature/How-SAP-BW-and-HANA-will-merge-over-time-and-why-it-matters">http://searchsap.techtarget.com/feature/How-SAP-BW-and-HANA-will-merge-over-time-and-why-it-matters</a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-59099394554037075242012-11-21T09:15:00.001+02:002012-11-21T09:16:25.343+02:00Sneak Peek of SAP BusinessObjects Dashboards 4.0 SP5<div dir="rtl" style="text-align: right;" trbidi="on">
<div class="separator" dir="ltr" style="clear: both; text-align: left;">
What's new in BusinessObjects Dashboards 4.0 SP5 ?</div>
<div class="separator" dir="ltr" style="clear: both; text-align: left;">
</div>
<div class="separator" dir="ltr" style="clear: both; text-align: left;">
"Dashboards 4.0 SP05 (formerly Xcelsius) will support iPad only in the first release. Publish your dashboard to the SAP BusinessObjects business intelligence platform and then download or run it on your iPad using SAP BusinessObjects Mobile. We may support other tablets in future releases..."</div>
<div class="separator" dir="ltr" style="clear: both; text-align: center;">
</div>
<div class="separator" dir="ltr" style="clear: both; text-align: center;">
</div>
<div class="separator" dir="ltr" style="clear: both; text-align: left;">
Get a Sneak Peek of SAP BusinessObjects Dashboards 4.0 SP5: How to Mobilize Your Dashboards</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<object class="BLOGGER-youtube-video" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" data-thumbnail-src="http://3.gvt0.com/vi/sMu8UShGw_c/0.jpg" height="266" width="450"><param name="movie" value="http://www.youtube.com/v/sMu8UShGw_c&fs=1&source=uds" /><param name="bgcolor" value="#FFFFFF" /><param name="allowFullScreen" value="true" /><embed width="450" height="266" src="http://www.youtube.com/v/sMu8UShGw_c&fs=1&source=uds" type="application/x-shockwave-flash" allowfullscreen="true"></embed></object></div>
<br /></div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com2tag:blogger.com,1999:blog-8380698146152975019.post-6836329719724898672012-11-21T09:09:00.001+02:002012-11-21T09:16:47.085+02:00What’s new in SAP BusinessObjects 4.0 SP5...<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: justify;">
Whats's new in BI4 platform ,SP5 ?</div>
<div dir="ltr" style="text-align: justify;">
</div>
<div dir="ltr" style="text-align: justify;">
Read here strating from page 81:</div>
<div dir="ltr" style="text-align: justify;">
</div>
<div dir="ltr" style="text-align: justify;">
<a href="http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_whats_new_en.pdf">http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_whats_new_en.pdf</a></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com3tag:blogger.com,1999:blog-8380698146152975019.post-75567007423198188202012-11-13T10:48:00.002+02:002012-11-21T09:17:05.393+02:00SAP BusinessObjects Dashboarding Strategy and Statement of Direction<div dir="rtl" style="text-align: right;" trbidi="on">
<div style="direction: ltr; text-align: justify;">
Where exactly is Dashboard design is heading for ?</div>
<div style="direction: ltr; text-align: justify;">
What will happen with flash ?</div>
<div style="direction: ltr; text-align: justify;">
How will Zen take it's part in this process ?</div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
<div style="direction: ltr; text-align: justify;">
Read hear for further understanding :<br />
<br />
<a href="http://scn.sap.com/community/bi-dashboards/blog/2012/06/08/follow-up-questions-to-the-dashboarding-statement-of-direction">http://scn.sap.com/community/bi-dashboards/blog/2012/06/08/follow-up-questions-to-the-dashboarding-statement-of-direction</a></div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
<div style="direction: ltr; text-align: justify;">
<a href="http://blogs.sap.com/wp-content/blogs.dir/2/files/2012/04/External-SAP-SOD-Dashboarding-2012.pdf">http://blogs.sap.com/wp-content/blogs.dir/2/files/2012/04/External-SAP-SOD-Dashboarding-2012.pdf</a></div>
<div style="direction: ltr; text-align: justify;">
<br /></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-9125467162925814792012-11-11T13:50:00.000+02:002012-11-21T09:17:33.846+02:00Exists or not exists- that is the answer<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
</div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;">Using more complex queries
that can answer simple question like who bought product A but didn't bought
product B? Or in another Case: which customers from the customer’s table don’t
have an order in the order table ,is one of the abilities that we would like to
give for the users and allow them to use it simply and freely as we can.</span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;">In order to do that we can
use in some cases the sub query method which is good and solid, but in some
cases using the Exist \ not exist would be better.<o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;">And why is that?<o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;">There are first of all performance
differences that makes the exists operator make a better work of evaluating
which is the </span><span class="normalarial"><span lang="EN" style="font-family: Verdana; mso-ansi-language: EN;">driving table and by doing so , use in some cases
the appropriate index ,there is also the ability to work with nulls.<o:p></o:p></span></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span class="normalarial"><span lang="EN" style="font-family: Verdana; mso-ansi-language: EN;">For a better understanding of the differences
between Exists and subquery read here: </span></span><span style="font-family: Verdana;"><o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;"><a href="http://www.ehow.com/info_8750242_differences-between-exists-sql.html">http://www.ehow.com/info_8750242_differences-between-exists-sql.html</a><o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;"><a href="http://www.techrepublic.com/article/oracle-tip-understand-the-difference-between-in-and-exists-in-subqueries/5297080">http://www.techrepublic.com/article/oracle-tip-understand-the-difference-between-in-and-exists-in-subqueries/5297080</a><o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;"><a href="http://weblogs.sqlteam.com/mladenp/archive/2007/05/18/60210.aspx">http://weblogs.sqlteam.com/mladenp/archive/2007/05/18/60210.aspx</a><o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;">Using the <st1:place w:st="on">Island</st1:place> resort we will use the Customer and the Sales
tables in order to answer a simple question:<o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana;">Who are the customers who
haven’t paid so far?<o:p></o:p></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<ol dir="ltr" start="1" style="margin-top: 0in; text-align: left;" type="1">
<li class="MsoNormal"><span style="font-family: Verdana;">first we will build the following predefined
condition using this syntax:<o:p></o:p></span></li>
</ol>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br />
<span style="font-family: Verdana;"><span style="font-size: 12px;">SELECT Customer.cust_id</span></span><br />
<span style="font-family: Verdana;"><span style="font-size: 12px;">FROM Customer</span></span><br />
<span style="font-family: Verdana;"><span style="font-size: 12px;"><br /></span></span>
<span style="font-family: Verdana;"><span style="font-size: 12px;">WHERE NOT EXISTS</span></span><br />
<span style="font-family: Verdana;"><span style="font-size: 12px;"><br /></span></span>
<span style="font-family: Verdana;"><span style="font-size: 12px;">(select Sales.cust_id </span></span><span style="font-family: Verdana; font-size: 12px;">from Sale </span><span style="font-family: Verdana; font-size: 12px;">where Customer.cust_id=Sales.cust_id)</span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana; font-size: 9pt;"><br /></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<span style="font-family: Verdana; font-size: 9pt;"><br /></span></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="separator" dir="ltr" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWdwXNfQkhyphenhyphenpyRWcn4fpgUHXEt1B06Nn98l5g6iFe8PomxAEcSWZl1W0-fKnhi73CzUeFfbzeEU0g7GDEPVF0wzuD5cfBRtYdvBtBvd3VtTovQlwr9ESlXmr6XtS1bb62s2X4bqoeA34o/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWdwXNfQkhyphenhyphenpyRWcn4fpgUHXEt1B06Nn98l5g6iFe8PomxAEcSWZl1W0-fKnhi73CzUeFfbzeEU0g7GDEPVF0wzuD5cfBRtYdvBtBvd3VtTovQlwr9ESlXmr6XtS1bb62s2X4bqoeA34o/s400/1.JPG" width="400" /></a></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<ol dir="ltr" start="2" style="margin-top: 0in; text-align: left;" type="1">
<li class="MsoNormal"><span style="font-family: Verdana;">We will create a simple query that returns the
customers ID’s :<o:p></o:p></span></li>
</ol>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkapJsSEMfa-bRNuq16SAOqG9NxBzTopq1lFsLmrgd1MalzinSnB_REJetd2V2hzX6_K_fTmkx65K0ogsHskZwyQyjykwLokh3OEAHB4BvTrYQpgvTgu2eGvKtPDDPsxwUzPfyURKMfBE/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkapJsSEMfa-bRNuq16SAOqG9NxBzTopq1lFsLmrgd1MalzinSnB_REJetd2V2hzX6_K_fTmkx65K0ogsHskZwyQyjykwLokh3OEAHB4BvTrYQpgvTgu2eGvKtPDDPsxwUzPfyURKMfBE/s400/2.JPG" width="400" /></a></div>
<ol dir="ltr" start="3" style="margin-top: 0in; text-align: left;" type="1">
<li class="MsoNormal"><span style="font-family: Verdana;">The result will be getting just those
customers who don’t have any invoice :<o:p></o:p></span></li>
</ol>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPIfbzaO0-FmYFoK9I4L4Otw83D3_aZ7UOjbWDb_kz3mU0Xt4Ik_qIIqod7OLkGj15gsoi_sXmai4qeNtDCwVx06BK5TryHWrcY7TYbJFJHZI3yHiX1zLHImrjgUh1vf5ffyr-NsrWzL8/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="289" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPIfbzaO0-FmYFoK9I4L4Otw83D3_aZ7UOjbWDb_kz3mU0Xt4Ik_qIIqod7OLkGj15gsoi_sXmai4qeNtDCwVx06BK5TryHWrcY7TYbJFJHZI3yHiX1zLHImrjgUh1vf5ffyr-NsrWzL8/s400/3.JPG" width="400" /></a></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
<div class="MsoNormal" dir="ltr" style="text-align: left;">
<br /></div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-1757799585066078392012-09-20T09:26:00.000+03:002012-09-20T10:14:16.466+03:00SAP Announces New Trial for Data Discovery at SAP BusinessObjects User Conference<div dir="rtl" style="text-align: right;" trbidi="on">
<div dir="ltr" style="text-align: left;">
Read here about the new exiting tool:</div>
<div dir="ltr" style="text-align: left;">
</div>
<div dir="ltr" style="text-align: left;">
<a href="http://blogs.sap.com/analytics/2012/09/19/sap-launches-new-trial-for-data-discovery-at-bi-user-conference/?utm_source=rss&utm_medium=rss&utm_campaign=sap-launches-new-trial-for-data-discovery-at-bi-user-conference">http://blogs.sap.com/analytics/2012/09/19/sap-launches-new-trial-for-data-discovery-at-bi-user-conference/?utm_source=rss&utm_medium=rss&utm_campaign=sap-launches-new-trial-for-data-discovery-at-bi-user-conference</a></div>
<div dir="ltr" style="text-align: left;">
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='420' height='266' src='https://www.youtube.com/embed/UWww7SQxngo?feature=player_embedded' frameborder='0'></iframe></div>
</div>
<div dir="ltr" style="text-align: left;">
</div>
</div>
yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-56766163880874092702012-06-17T10:19:00.000+03:002012-06-17T10:19:56.895+03:00SAP Dashboard BI 4.0 Feature Pack 3 Planned Features<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;">What's new in BI4 Dashboard design feature pack 3 ?</div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"><a href="http://scn.sap.com/community/bi-dashboards/blog/2011/11/25/sap-dashboard-bi-40-feature-pack-3-planned-features-asug-webcast-summary">http://scn.sap.com/community/bi-dashboards/blog/2011/11/25/sap-dashboard-bi-40-feature-pack-3-planned-features-asug-webcast-summary</a></div></div>yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-75007095955807651932012-03-21T06:30:00.000+02:002012-03-21T06:30:59.792+02:00What's New -SAP BusinessObjects Business Intelligence Suite 4.0 Feature Package 3<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;">Here is the official PDF:</div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"><a href="http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_whats_new_FP3_en.pdf">http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_whats_new_FP3_en.pdf</a></div></div>yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-65887565778751291152012-03-01T07:15:00.001+02:002012-03-01T07:16:09.812+02:00What's New in Mobile BI ?<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;">What's new in SAP BI Mobile ?</div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"></div><div class="MsoNormal" dir="ltr" style="margin: 0cm 0cm 10pt; text-align: left; unicode-bidi: embed;"><span style="font-family: Calibri;">According to the following link iphone devices are currently supporting SAP Explorer, still much to come in Feature pack 3 where also Android devices will be supported :</span></div><div dir="ltr" style="text-align: left;"><a href="http://www.sap.com/campaigns/2011_08_mobile-analytics/see-it-in-action/index.epx">http://www.sap.com/campaigns/2011_08_mobile-analytics/see-it-in-action/index.epx</a></div></div>yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-48288250277579686472012-01-09T07:48:00.002+02:002012-01-09T07:57:06.512+02:00BI4 Feature Pack 3 Planned Features for the BI Platform<div dir="rtl" style="text-align: right;" trbidi="on"><div align="left" dir="ltr" style="text-align: left;">What new features awaits in BI4 feature pack 3 ?</div><div align="left" dir="ltr" style="text-align: left;"><br />
</div><div align="left" dir="ltr" style="text-align: left;">Some Highlights :</div><div align="left" dir="ltr" style="text-align: left;"><br />
</div><ul dir="ltr" style="text-align: left;"><li><div style="text-align: left;">Call from Bex query to a web address,another Bex query (via report linking )</div></li>
</ul><div dir="ltr" style="text-align: left;">see here for more details :</div><div dir="ltr" style="text-align: left;"><a href="http://help.sap.com/saphelp_nw70ehp2/Helpdata/EN/99/08629bd3e41d418530c6849df303c9/content.htm">http://help.sap.com/saphelp_nw70ehp2/Helpdata/EN/99/08629bd3e41d418530c6849df303c9/content.htm</a></div><ul dir="ltr" style="text-align: left;"><li><div style="text-align: left;">OEM support</div></li>
<li><div style="text-align: left;">Use custom user attributes for enhanced security in IDT</div></li>
<li><div style="text-align: left;">Bi Launch Pad supports theming</div></li>
<li><div style="text-align: left;">SAP Streamwork integration with BI Launch Pad</div></li>
<li><div style="text-align: left;">Hot full automated backup of the repository (DB +FRS )</div></li>
</ul><div dir="ltr" style="text-align: left;">For further reading here <span class="sapTxtSml" style="font-weight: normal;"><nobr>Tammy Powlas article :</nobr></span></div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"><span class="sapTxtSml" style="font-weight: normal;"><nobr><a href="http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27890">http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27890</a></nobr></span></div></div>yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-84979087662996840772011-12-13T08:06:00.003+02:002011-12-13T08:54:45.325+02:00SAP to Deliver Integrated Social Analytics to the Enterprise<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;">"SAP Social Media Analytics by NetBase enables enterprises to create an enterprise social analytics platform that offers a wider and deeper perspective on a range of activities"...<br />
<br />
This tool allows organizations to extract unstructured data from the web (95 million social media posts daily from Twitter, Facebook, news feeds, blogs and other sources) and by that analyse trends,feedbacks<br />
,requests and many other data items that can bring a better understanding of the business work flow.<br />
<br />
Watch this new Video :<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="300" src="http://www.youtube.com/embed/jMfYX3LgPJ0" width="500"></iframe></div></div>yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0tag:blogger.com,1999:blog-8380698146152975019.post-17352335942081225842011-12-04T07:35:00.003+02:002011-12-04T07:48:55.912+02:00SAP pays $3.4B for cloud vendor SuccessFactors<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;">SAP is about to acquire SuccessFactors ,a provider of cloud-based human capital management tools.</div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;">In order to become a major player in the cloud and cloud BI business and compete with already in motion vendors like Oracle,Informatica,Salesforce and Microstrategy.</div><div dir="ltr" style="text-align: left;">Click here for the original article :</div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"><a href="http://www.computerworld.com/s/article/9222397/Update_SAP_pays_3.4B_for_cloud_vendor_SuccessFactors">http://www.computerworld.com/s/article/9222397/Update_SAP_pays_3.4B_for_cloud_vendor_SuccessFactors</a></div><div dir="ltr" style="text-align: left;"></div></div>yoavhttp://www.blogger.com/profile/06340156995408714351noreply@blogger.com0