tag:blogger.com,1999:blog-35367087663058190962024-03-13T20:13:00.388+01:00SFRaoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3536708766305819096.post-40303309532470134952017-11-27T11:52:00.001+01:002020-09-16T21:21:26.105+02:00Colored projects on a planning reportWhat if you want to create a planning report where the projects have different colors like this:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-2dJMrOlwSJQ/Whvrfq66BDI/AAAAAAAAEYw/lBtMUjBCV3kk0CWsfTXzZmpSp7KVI8_4gCLcBGAs/s1600/planning%2Bwithout%2Bthe%2Blines.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="469" src="https://3.bp.blogspot.com/-2dJMrOlwSJQ/Whvrfq66BDI/AAAAAAAAEYw/lBtMUjBCV3kk0CWsfTXzZmpSp7KVI8_4gCLcBGAs/s1600/planning%2Bwithout%2Bthe%2Blines.png" /></a></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
<br /></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
</div>
<br />
And not like this: <a href="https://3.bp.blogspot.com/-Tlnx4KXbRFI/Whvr80PGdKI/AAAAAAAAEY4/PpLxc3HzZP8zEDXRXyIvv5yb3ZdVzObogCEwYBhgL/s1600/planning%2Bwith%2Blines.png" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="18" data-original-width="140" src="https://3.bp.blogspot.com/-Tlnx4KXbRFI/Whvr80PGdKI/AAAAAAAAEY4/PpLxc3HzZP8zEDXRXyIvv5yb3ZdVzObogCEwYBhgL/s1600/planning%2Bwith%2Blines.png" /></a> or <a href="https://2.bp.blogspot.com/-JpbngGdXzkI/XK2X7DMV2bI/AAAAAAAAGX0/AR1x2O6SHp8TVDI9AZVVF-65iELa3bUCQCLcBGAs/s1600/planning%2Bwith%2Blines%2B2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="18" data-original-width="140" src="https://2.bp.blogspot.com/-JpbngGdXzkI/XK2X7DMV2bI/AAAAAAAAGX0/AR1x2O6SHp8TVDI9AZVVF-65iELa3bUCQCLcBGAs/s1600/planning%2Bwith%2Blines%2B2.png" /></a><br />
<br />
Keep in mind that table cells are formatted from left to right, first the cell on the left, then the one on the right.<br />
<br />
First step is to remove the black cell border on the right side of each cell:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-vHVhXspjc-E/WhvsYvTnFxI/AAAAAAAAEY8/3jpNd2Bm3Xom5sntyRdvg5wGfmDoxW4iwCLcBGAs/s1600/cell%2Bborder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="434" data-original-width="584" src="https://4.bp.blogspot.com/-vHVhXspjc-E/WhvsYvTnFxI/AAAAAAAAEY8/3jpNd2Bm3Xom5sntyRdvg5wGfmDoxW4iwCLcBGAs/s1600/cell%2Bborder.png" /></a></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
<br /></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Then create a conditional formatting rule to add a matching color cell border on the left side:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-4FRZYOvOr60/Whvtty3R1KI/AAAAAAAAEZI/pRlqhlUYmcc6qc17gzGRJgrTBYsm0d5ZwCLcBGAs/s1600/conditonal%2Bformatting%2Bcell%2Bborder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="364" data-original-width="431" src="https://2.bp.blogspot.com/-4FRZYOvOr60/Whvtty3R1KI/AAAAAAAAEZI/pRlqhlUYmcc6qc17gzGRJgrTBYsm0d5ZwCLcBGAs/s1600/conditonal%2Bformatting%2Bcell%2Bborder.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Raoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.com0tag:blogger.com,1999:blog-3536708766305819096.post-52108748125067527452017-07-07T09:50:00.001+02:002020-09-16T21:21:11.428+02:00The BO security model: simplicityIn this blog series I will share insights I've gathered over the years on how to setup an effective security model: simple, structured, maintainable, flexible, expandable and easy to use.<br />
In this fourth part of the series I will focus on simplicity. As stated the goal is to create a security model that is simple and structured.<br />
<div>
<br />
<div style="background: rgb(221, 221, 221); border: 1pt solid; margin-left: 35.4pt; margin-right: 0cm; padding: 1pt 4pt;">
<div class="MsoListParagraphCxSpFirst" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series is aimed at experienced BO administrators, which means there will be no how-to screenshots<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series can be used as a guideline, it cannot be used as a manual<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series only covers the internal BO stuff. No windows AD or SAP roles and no IAM software<o:p></o:p></div>
</div>
<br />
<br /></div>
Raoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.com0tag:blogger.com,1999:blog-3536708766305819096.post-73864390946001532017-01-14T22:20:00.002+01:002020-09-16T21:20:28.886+02:00The BO security model: object namesIn this blog series I will share insights I’ve gathered over the years on how to setup an effective security model: simple, structured, maintainable, flexible, expandable and easy to use.<br />
In this third part of the series I will focus on the names of objects. As stated the goal is to create a security model that is simple and structured. The object names play a big part in this.<br />
<div>
<br />
<div style="background: rgb(221, 221, 221); border: 1pt solid; margin-left: 35.4pt; margin-right: 0cm; padding: 1pt 4pt;">
<div class="MsoListParagraphCxSpFirst" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series is aimed at experienced BO administrators, which means there will be no how-to screenshots<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series can be used as a guideline, it cannot be used as a manual<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series only covers the internal BO stuff. No windows AD or SAP roles and no IAM software</div>
</div>
</div>
<br />
<h4>
User types</h4>
Let’s assume there are four types of users on your systems:<br />
<ul>
<li>Endusers</li>
<li>Analysts</li>
<li>Reporters</li>
<li>Designers</li>
</ul>
Where each type is an extension of the previous one, so there is some kind of structure in these types.<br />
<br />
Per type there will be a user group and a CAL.<br />
<div style="text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-xp8Py4BPR8A/WFqoeYw6PZI/AAAAAAAADxU/awt554xTuMQ5Z-fa5Ex37hsK1rvUo2jogCLcB/s1600/temp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-xp8Py4BPR8A/WFqoeYw6PZI/AAAAAAAADxU/awt554xTuMQ5Z-fa5Ex37hsK1rvUo2jogCLcB/s1600/temp.png" /></a> <a href="https://2.bp.blogspot.com/-5_KbAItu7Oo/WFqpQu79seI/AAAAAAAADxY/LaXNa11Eo_QHV_oQTzn6P9-wOsEc8USCwCLcB/s1600/temp2.png" imageanchor="1" style="clear: right; display: inline !important; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://2.bp.blogspot.com/-5_KbAItu7Oo/WFqpQu79seI/AAAAAAAADxY/LaXNa11Eo_QHV_oQTzn6P9-wOsEc8USCwCLcB/s1600/temp2.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
When I assign these user groups to folders it looks like this:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-o0k_VRZQuWg/WFqnrjDFXLI/AAAAAAAADxM/E3L2lo3cw7g5PFLw1qfznmFSVABGYKDOgCLcB/s1600/comments%2Baccess%2Brights%2B5d.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://3.bp.blogspot.com/-o0k_VRZQuWg/WFqnrjDFXLI/AAAAAAAADxM/E3L2lo3cw7g5PFLw1qfznmFSVABGYKDOgCLcB/s1600/comments%2Baccess%2Brights%2B5d.png" /></a></div>
<br />
Although they are sorted alphabetically I don’t like that very much, So I make a little change to the user type user groups, to make use of the alphabetic sort:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-NC_78FuG8VA/WFqnrqXEFvI/AAAAAAAADxQ/Y7hGPGlm3hEOCQLJYZFXBpYZAGm87iRqgCLcB/s1600/comments%2Baccess%2Brights%2B5c.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-NC_78FuG8VA/WFqnrqXEFvI/AAAAAAAADxQ/Y7hGPGlm3hEOCQLJYZFXBpYZAGm87iRqgCLcB/s1600/comments%2Baccess%2Brights%2B5c.png" /></a></div>
<br />
After this little name change it’s much easier on the eye. And it’s making the model a bit more structured.<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<h4>
Organisation user groups</h4>
Lets add a department to the system, Sales. I create folders which represent the structure of the sales department and corresponding user groups. Theses folders and user groups are used to define access. Both have the same structure but the don't have the same names.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-WZSJztsRpEg/WGD2w-xj4WI/AAAAAAAADx4/sCxx3yGo1IQ8qpy9F4lDH7bOiWlkAacaACLcB/s1600/rty67.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-WZSJztsRpEg/WGD2w-xj4WI/AAAAAAAADx4/sCxx3yGo1IQ8qpy9F4lDH7bOiWlkAacaACLcB/s1600/rty67.png" /></a></div>
<br />
Doing this makes them appear neatly ordered when they are assigned to the folders:<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-34c4C1zmrtE/WGKWAWfsfQI/AAAAAAAADzM/RETZN0Xsux45-DjYd258UHR7cjqMBL3KgCLcB/s1600/Sales%2Bassigment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-34c4C1zmrtE/WGKWAWfsfQI/AAAAAAAADzM/RETZN0Xsux45-DjYd258UHR7cjqMBL3KgCLcB/s1600/Sales%2Bassigment.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-HqTf9G73inQ/WGKU4cyRw_I/AAAAAAAADy4/6co09ZzGDq8uqhy-KXQzr7Jggy9O0Sc-QCLcB/s1600/Sales%2BEMEA%2Bassignment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-HqTf9G73inQ/WGKU4cyRw_I/AAAAAAAADy4/6co09ZzGDq8uqhy-KXQzr7Jggy9O0Sc-QCLcB/s1600/Sales%2BEMEA%2Bassignment.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-X_tCDL60Uu0/WGKU4WpX4jI/AAAAAAAADy8/34nzO7vn06U0l_5RGdDsz0cRsdchh1EQgCLcB/s1600/Sales%2BEMEA%2BNL%2Bassignment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-X_tCDL60Uu0/WGKU4WpX4jI/AAAAAAAADy8/34nzO7vn06U0l_5RGdDsz0cRsdchh1EQgCLcB/s1600/Sales%2BEMEA%2BNL%2Bassignment.png" /></a></div>
<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 29.75pt; mso-border-alt: solid windowtext .5pt; mso-border-insideh: none; mso-border-insidev: none; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 356px;">
<tbody>
<tr>
<td style="border-bottom: solid windowtext 1.0pt; border-left: solid windowtext 1.0pt; border-right: none; border-top: solid windowtext 1.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 53.75pt;" valign="top" width="72"><div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-3vqMqJcx5ic/WEbV11sf7MI/AAAAAAAADtA/BdpC2oO8AQI-PaWyIHZs6wIQRktbJCsowCPcB/s1600/info.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-3vqMqJcx5ic/WEbV11sf7MI/AAAAAAAADtA/BdpC2oO8AQI-PaWyIHZs6wIQRktbJCsowCPcB/s1600/info.png" /></a></div>
<div class="MsoNormal">
<!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_52" o:spid="_x0000_i1027" type="#_x0000_t75"
style='width:42.75pt;height:40.5pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p></o:p></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: none; border-top: solid windowtext 1.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 201.15pt;" valign="top" width="268"><div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Total user security on folder Sales \ EMAE \ NL now looks like this: <o:p></o:p></div>
<div class="MsoNormal">
<!--[if gte vml 1]><v:shape
id="Picture_x0020_22" o:spid="_x0000_i1026" type="#_x0000_t75" style='width:164.25pt;
height:67.5pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image003.png"
o:title="" croptop="18495f" cropbottom="10855f" cropleft="593f"/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-e7uezJK8MMw/WGo_DRTKvnI/AAAAAAAAD64/TywiY7Zk5Wo39aB1y8Qqf4kSOI7Ej7xHwCLcB/s1600/rtythjyujy.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-e7uezJK8MMw/WGo_DRTKvnI/AAAAAAAAD64/TywiY7Zk5Wo39aB1y8Qqf4kSOI7Ej7xHwCLcB/s1600/rtythjyujy.png" /></a></div>
<br />
<div class="MsoNormal">
<!--[if gte vml 1]><v:shape
id="Picture_x0020_20" o:spid="_x0000_i1025" type="#_x0000_t75" style='width:165.75pt;
height:335.25pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image005.png"
o:title="" croptop="437f" cropbottom="-1f"/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: solid windowtext 1.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 11.8pt;" valign="top" width="16"><div class="MsoNormal">
<br /></div>
</td>
</tr>
</tbody></table>
Raoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.com0tag:blogger.com,1999:blog-3536708766305819096.post-15837789484495172082016-12-17T21:31:00.000+01:002020-09-16T21:20:18.517+02:00The BO security model: an introduction<div class="MsoNormal">
Over the years I have seen a lot of BO security models. Probably most of them were quite nice when they were implemented. They always start out as simple and structured models and everybody is determined to keep it that way. I am sure that if there were no business users on the system it would stay that way, simple and structured. But in real life a security model evolves, new business departments join and have different needs: we don’t want everybody to be able to schedule reports. More mature BO users may come up with extra needs: we want some users to only see their own instances and others to see all instances. The system grows: we only want to see a list of our colleague’s when we sent a report not the whole world. And new functionality to BO is added, like the commentary in BO 4.2.<br />
<div>
<br /></div>
<div>
<div>
After some time the simple and structured model begins to turn into a <a href="http://www.laputan.org/mud/" target="_blank">big ball of mud</a>: haphazardly structured, sprawling, sloppy, duct-tape and bailing wire: </div>
<div>
<br />
<ul>
<li>complete custom access levels (CAL) are copied and then one little thingy is changed</li>
<li>user groups are created with weird names and very specific functions</li>
<li>users are directly assigned to folders and given advanced rights </li>
</ul>
</div>
<div>
<br /></div>
<div>
In this blog series I would like to share some insight I gathered over the years. These can serve as guidelines the next time you have to work on a model. </div>
</div>
<div>
<br />
<div style="background: #DDDDDD; border: solid windowtext 1.0pt; margin-left: 35.4pt; margin-right: 0cm; mso-background-themecolor: accent5; mso-background-themetint: 102; mso-border-alt: solid windowtext .5pt; mso-element: para-border-div; padding: 1.0pt 4.0pt 1.0pt 4.0pt;">
<div class="MsoListParagraphCxSpFirst" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]-->This blog series is aimed at experienced BO
administrators, which means there will be no how-to screenshots<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]-->This blog series can be used as a guideline, it
cannot be used as a manual<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; margin-left: 18pt; padding: 0cm; text-indent: -18pt;">
<!--[if !supportLists]--><span style="font-family: "symbol"; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;"> </span></span>This blog series only covers the
internal BO stuff. No windows AD or SAP roles and no IAM software<o:p></o:p></div>
</div>
<br />
When I’m implementing a new security model I want it to be
effective. Where effective stands for: simple and structured. But also
maintainable, flexible, expandable and easy to use.</div>
<div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
Simple, structured, maintainable, flexible, expandable and
easy to use. That’s a lot! Well actually they are interrelated, if you give it
structure and keep it simple it will be easy to use and maintain. And if
you’re lucky it turns out to be flexible and expandable as well. <o:p></o:p><br />
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 29.75pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 574px;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 42.3pt;" valign="top" width="56"><div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-CqMsYfLCAzs/WEV-8FQPbmI/AAAAAAAADq4/l16esSmvKX4Fqo7yrQlJh_M6iX767_wUwCEw/s1600/tip.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Tip" border="0" src="https://4.bp.blogspot.com/-CqMsYfLCAzs/WEV-8FQPbmI/AAAAAAAADq4/l16esSmvKX4Fqo7yrQlJh_M6iX767_wUwCEw/s1600/tip.png" title="" /></a></div>
<div class="MsoNormal">
<!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_40" o:spid="_x0000_i1025" type="#_x0000_t75"
style='width:27pt;height:27.75pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 388.4pt;" valign="top" width="518"><div class="MsoNormal">
I never re-use any of the existing CALs because I don’t
want to mess with the existing model. When you create new CALs you can run
both models on the same system for comparison and testing. And reverting to
the original model in case of issues is easy, just delete all the new CALs.</div>
</td>
</tr>
</tbody></table>
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 29.75pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 574px;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 42.3pt;" valign="top" width="56"><div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-CqMsYfLCAzs/WEV-8FQPbmI/AAAAAAAADq4/l16esSmvKX4Fqo7yrQlJh_M6iX767_wUwCEw/s1600/tip.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="Tip" border="0" src="https://4.bp.blogspot.com/-CqMsYfLCAzs/WEV-8FQPbmI/AAAAAAAADq4/l16esSmvKX4Fqo7yrQlJh_M6iX767_wUwCEw/s1600/tip.png" title="" /></a></div>
<div class="MsoNormal">
<!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_18" o:spid="_x0000_i1025" type="#_x0000_t75"
style='width:27pt;height:27.75pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 388.4pt;" valign="top" width="518"><div class="MsoNormal">
I prefer to create the new model on a sandbox machine and
when it’s finished and tested, promote it to a live system. Start with
development, then test, UAT and production. When issues are found resolve
them, go back to the sandbox, make the same adjustments to your model and
start promoting again.</div>
</td>
</tr>
</tbody></table>
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 29.75pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184; width: 574px;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 42.3pt;" valign="top" width="56"><div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<a href="https://4.bp.blogspot.com/-CqMsYfLCAzs/WEV-8FQPbmI/AAAAAAAADq4/uHD-bKWpNuoUvpMwV8UlnoEuvJ0LAcybwCLcB/s1600/tip.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img alt="Tip" border="0" src="https://4.bp.blogspot.com/-CqMsYfLCAzs/WEV-8FQPbmI/AAAAAAAADq4/uHD-bKWpNuoUvpMwV8UlnoEuvJ0LAcybwCLcB/s1600/tip.png" title="" /></a><br />
<div class="MsoNormal">
<!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_36" o:spid="_x0000_i1025" type="#_x0000_t75"
style='width:27pt;height:27.75pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 388.4pt;" valign="top" width="518"><div class="MsoNormal">
If a model is a mess, don’t recreate the mess in a
structured way. If a model is a mess manage expectations and preach that the
new model will not be exactly like the old one.</div>
</td>
</tr>
</tbody></table>
</div>
</div>
<div class="MsoNormal">
<div class="MsoNormal">
<br /></div>
<div>
A BO security model consists of: </div>
<div>
<div>
<div>
<ul>
<li>access rights (view, edit, delete etc.) </li>
<li>users </li>
<li>objects (reports, universes, connections etc.) </li>
<li><span class="Apple-tab-span" style="white-space: pre;">assignments</span>: the relations between them </li>
</ul>
</div>
</div>
<div>
There are hundreds of access rights, they will be grouped in custom access levels (CALs).<br />
There can be hundreds of objects, they will be grouped in folders.<br />
There can be hundreds of users, they will be grouped in user groups<br />
<br />
In the assignments I will only use these grouped items: folders, user groups and CALs.<br />
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: 29.6pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 42.3pt;" valign="top" width="56"><div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-mi7lRDwRG0U/WEWOmVVbDLI/AAAAAAAADrY/Blb8kW2WuigGGIn0rbzYrR11bDUb-_NswCPcB/s1600/skull.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-mi7lRDwRG0U/WEWOmVVbDLI/AAAAAAAADrY/Blb8kW2WuigGGIn0rbzYrR11bDUb-_NswCPcB/s1600/skull.png" /></a></div>
<div class="MsoNormal">
<!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_41" o:spid="_x0000_i1025" type="#_x0000_t75"
style='width:24pt;height:23.25pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\labegare\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 388.4pt;" valign="top" width="518"><div class="MsoNormal">
It is a humongous mistake maybe even a mortal sin to
assign directly on an object ! Even if it is only once !<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Exception:</b> Calendars don’t have a
folder structure, if you want Calendars to not be visible to everybody you
should grant access on object level.</div>
</td>
</tr>
</tbody></table>
<span style="font-family: "times new roman" , serif; font-size: 11pt;"><br /></span>
<span style="font-family: "times new roman" , serif; font-size: 11pt;">In the next blog I will talk about the structure
of the model from a very high level.</span></div>
</div>
<div>
<br /></div>
</div>
</div>
Raoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.com0tag:blogger.com,1999:blog-3536708766305819096.post-73764400693640326552015-02-07T17:19:00.001+01:002020-09-16T21:24:19.723+02:00Lean WebI customizationIn 4.1 there is this new feature to customise the Web Intelligence interface. It's a nice feature, but can it be useful? Yes it can, well at least I think so.<br />
<br />
When this feature is combined with opendocument there is a huge visual impact. And this can be very useful, especially when the opendocument link comes from outside of BO, for example a sharepoint portal. Changes are that the business user clicking this report link doesn't know anything about BO Web Intelligence.<br />
<br />
The 'standard' opendocument view is something like this<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Nof2eWrMtDY/VNY2VM89zDI/AAAAAAAACyE/H1OcAhYG9Hg/s1600/Opendocument%2B-%2Bstandard%2Bview.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Nof2eWrMtDY/VNY2VM89zDI/AAAAAAAACyE/H1OcAhYG9Hg/s1600/Opendocument%2B-%2Bstandard%2Bview.png" height="379" width="640" /></a></div>
<br />
But realizing that the business user knows nothing about Web Intelligence, there is a lot of visual noise and cluttering on this screen. Lets make some customization and remove all the Web Intelligence stuff to make it lean.<br />
<br />
I created an extra usergroup in BO and assigned the business user to this group. For this usergroup I set the customization:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-NsHApryxtFg/VNY5yW_S3rI/AAAAAAAACyY/TT81nPlRhNg/s1600/WebI%2Blean%2Bcustomization.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-NsHApryxtFg/VNY5yW_S3rI/AAAAAAAACyY/TT81nPlRhNg/s1600/WebI%2Blean%2Bcustomization.png" /></a></div>
<br />
Now the 'lean' opendocument view is presented:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-EYCx5GP1iz4/VNY5cESJtXI/AAAAAAAACyQ/G7RKuHsrpXI/s1600/Opendocument%2B-%2Blean%2Bview.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-EYCx5GP1iz4/VNY5cESJtXI/AAAAAAAACyQ/G7RKuHsrpXI/s1600/Opendocument%2B-%2Blean%2Bview.png" height="380" width="640" /></a></div>
<br />
This is much better!Raoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.com0tag:blogger.com,1999:blog-3536708766305819096.post-17175922955896306122014-04-09T19:22:00.002+02:002020-09-16T21:25:01.049+02:00Starting with BI WorkspacesWorkspaces are a unknown part of the BusinessObjects environment and maybe also an underestimated part, Workspaces are created in the BI Launchpad. They can be used as landing page or they can be opened from the launchpad manually.<br />
What I am going to show here is how to build a very simple workspace with templates.<br />
Open the workspace editor using the Application menu in the BI Launchpad.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-mTxWeI-9brQ/WFWwhAnqiKI/AAAAAAAADu0/r1P3SMN8dLg2_wz72xUDBZ__IOZfORGswCLcB/s1600/Workspaces%2B-%2Bapp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-mTxWeI-9brQ/WFWwhAnqiKI/AAAAAAAADu0/r1P3SMN8dLg2_wz72xUDBZ__IOZfORGswCLcB/s1600/Workspaces%2B-%2Bapp.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
Click the layout dropdown box and change to Freeform.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-kR2pcqi7LVI/WFWxG6kMuXI/AAAAAAAADu8/rRiTlWwMsl40eLnn_Nr_MYOAbUqJDKPggCLcB/s1600/Workspaces%2B-%2Blayout.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://3.bp.blogspot.com/-kR2pcqi7LVI/WFWxG6kMuXI/AAAAAAAADu8/rRiTlWwMsl40eLnn_Nr_MYOAbUqJDKPggCLcB/s1600/Workspaces%2B-%2Blayout.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
On an empty workspace drag in a navigation list component.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-NTgn7snKZn8/WFWxi77A_4I/AAAAAAAADvA/IW9WbgyEHPA-tuyf1r_NgsEbBmIm7LKbACLcB/s1600/Workspace%2B-%2Bnav%2Blist%2B3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-NTgn7snKZn8/WFWxi77A_4I/AAAAAAAADvA/IW9WbgyEHPA-tuyf1r_NgsEbBmIm7LKbACLcB/s1600/Workspace%2B-%2Bnav%2Blist%2B3.png" /></a></div>
<br />
Edit it using the wrench symbol in the top right corner and select 2 webi report. Or drag and drop 2 webi reports on the navigation list.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-DRmU3xnukuI/WFWyyNjiovI/AAAAAAAADvI/RNbxvWSrxYUvPTbxZNQgWm8-YOn7JlxVgCLcB/s1600/Workspace%2B-%2Bnav%2Blist%2B2a.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://3.bp.blogspot.com/-DRmU3xnukuI/WFWyyNjiovI/AAAAAAAADvI/RNbxvWSrxYUvPTbxZNQgWm8-YOn7JlxVgCLcB/s1600/Workspace%2B-%2Bnav%2Blist%2B2a.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
There it is, it’s done. Your first workspace. Now you can save it and execute it from the BI Launchpad. You do not have to save it, exiting edit mode gives you a change to test the new workspace.<br />
<br />
When you click 1 of the reports on the navigation list, by default, the report runs it the total workspace window. Click the square symbol on the left side to return to the navigation list.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-4UNovEBH2xQ/WFW0DcbB96I/AAAAAAAADvU/366Wxg-b7MwK4Pvd5ullgGZDdTnkRRoegCLcB/s1600/Workspace%2B1%2B-%2B2a.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-4UNovEBH2xQ/WFW0DcbB96I/AAAAAAAADvU/366Wxg-b7MwK4Pvd5ullgGZDdTnkRRoegCLcB/s1600/Workspace%2B1%2B-%2B2a.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-IeiP4_IhoHk/WFW08D8787I/AAAAAAAADvY/6-kt9Yd9x_UvgFoOif3J6m7QulJwzwU-wCLcB/s1600/Workspace%2B1%2B-%2B3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://4.bp.blogspot.com/-IeiP4_IhoHk/WFW08D8787I/AAAAAAAADvY/6-kt9Yd9x_UvgFoOif3J6m7QulJwzwU-wCLcB/s640/Workspace%2B1%2B-%2B3.png" width="610" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
And when the other report is clicked:</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-w99fVjUk-_c/WFW2qMjV_uI/AAAAAAAADvk/t1o7pbX9NQ0mLOo_uuS2jmm_qY5a_D-awCLcB/s1600/Workspace%2B1%2B-%2B2b.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-w99fVjUk-_c/WFW2qMjV_uI/AAAAAAAADvk/t1o7pbX9NQ0mLOo_uuS2jmm_qY5a_D-awCLcB/s1600/Workspace%2B1%2B-%2B2b.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-B2Qv9zfA6EQ/WFW3uVo0uMI/AAAAAAAADv4/NWzbOkgwZ_EM2rytU7VaOAV_Tt1iy1AAQCLcB/s1600/Workspace%2B1%2B-%2B5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://1.bp.blogspot.com/-B2Qv9zfA6EQ/WFW3uVo0uMI/AAAAAAAADv4/NWzbOkgwZ_EM2rytU7VaOAV_Tt1iy1AAQCLcB/s640/Workspace%2B1%2B-%2B5.png" width="600" /></a></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;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
If you want to run the webi report in a part of the workspace window, you need to drag in a viewer component. No configuration is needed, the are connected automatically.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-1LZfbHKi6gc/WFW5JjYN-MI/AAAAAAAADwE/2RnLPwbbZsIxPP1ipSFjSzhjg9pUXpEcQCLcB/s1600/Workspace%2B-%2Bviewer%2B3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-1LZfbHKi6gc/WFW5JjYN-MI/AAAAAAAADwE/2RnLPwbbZsIxPP1ipSFjSzhjg9pUXpEcQCLcB/s1600/Workspace%2B-%2Bviewer%2B3.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></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;">
<a href="https://3.bp.blogspot.com/-OGPgNmJYgHA/WFW6QbSe7bI/AAAAAAAADwQ/dx-D0a_ij944MLEm04UP1mldvhDF1qq1ACLcB/s1600/Workspace%2B2%2B-%2B1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://3.bp.blogspot.com/-OGPgNmJYgHA/WFW6QbSe7bI/AAAAAAAADwQ/dx-D0a_ij944MLEm04UP1mldvhDF1qq1ACLcB/s1600/Workspace%2B2%2B-%2B1.png" /></a></div>
<br />
<br />
Click one of the reports:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-n7vnHhOEj94/WFW-DVw0DTI/AAAAAAAADwg/h3tohyTh9wQ05ZGGxKQ40OMuehPawysFQCEw/s1600/Workspace%2B2%2B-%2B2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-n7vnHhOEj94/WFW-DVw0DTI/AAAAAAAADwg/h3tohyTh9wQ05ZGGxKQ40OMuehPawysFQCEw/s1600/Workspace%2B2%2B-%2B2.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="" style="clear: both; text-align: left;">
And click the other report:</div>
<div class="" style="clear: both; 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://1.bp.blogspot.com/-NFnY52HvSmA/WFW-DY9FBXI/AAAAAAAADwk/k6tnEjngDH45nNubUSQU6lkJzoIARoPCgCEw/s1600/Workspace%2B2%2B-%2B3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-NFnY52HvSmA/WFW-DY9FBXI/AAAAAAAADwk/k6tnEjngDH45nNubUSQU6lkJzoIARoPCgCEw/s1600/Workspace%2B2%2B-%2B3.png" /></a></div>
<br />
If there are multiple navigation lists and multiple viewers on the workspace some configuration is needed.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-2zB1KBvoNqY/WPx7GbRh3rI/AAAAAAAAEGk/WMiMidaOh8UZPyoBiOJPn6juTWfxqjGuACEw/s1600/Workspace%2B4%2B-%2B1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-2zB1KBvoNqY/WPx7GbRh3rI/AAAAAAAAEGk/WMiMidaOh8UZPyoBiOJPn6juTWfxqjGuACEw/s1600/Workspace%2B4%2B-%2B1.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-N0f9WBKb0Yo/WPx7GqBYGFI/AAAAAAAAEGo/HBC-o8kcHAwSY7DAT15VSCgLHQDl97hjACEw/s1600/Workspace%2B4%2B-%2B2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-N0f9WBKb0Yo/WPx7GqBYGFI/AAAAAAAAEGo/HBC-o8kcHAwSY7DAT15VSCgLHQDl97hjACEw/s1600/Workspace%2B4%2B-%2B2.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-xtl-WmNd0Ug/WPx7Gvl_VeI/AAAAAAAAEGs/fCyHdvFJ6sUB3Gl1_PdkS9FXo1gVtB6FACEw/s1600/Workspace%2B4%2B-%2B3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://3.bp.blogspot.com/-xtl-WmNd0Ug/WPx7Gvl_VeI/AAAAAAAAEGs/fCyHdvFJ6sUB3Gl1_PdkS9FXo1gVtB6FACEw/s1600/Workspace%2B4%2B-%2B3.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
I named the viewers top and bottom (using the edit / wrench of the viewers).<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-ma1NGEDJ_iM/WPx7G3OKrsI/AAAAAAAAEG4/wxNP1JBGWq4iMBJlcqfpZQxYdk7t5mOrwCEw/s1600/Workspace%2B4%2B-%2B4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="115" src="https://2.bp.blogspot.com/-ma1NGEDJ_iM/WPx7G3OKrsI/AAAAAAAAEG4/wxNP1JBGWq4iMBJlcqfpZQxYdk7t5mOrwCEw/s320/Workspace%2B4%2B-%2B4.png" width="320" /></a></div>
<br />
<br />
Then I connected each navigation list to a specific viewer. (using the edit / wrench of the navigation lists).<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-YYt-pFvZu80/WPx7GxCAYRI/AAAAAAAAEG4/iEKlDeI05gs2xyRFhhbFKpYz0cY_Jr_bQCEw/s1600/Workspace%2B4%2B-%2B5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="186" src="https://3.bp.blogspot.com/-YYt-pFvZu80/WPx7GxCAYRI/AAAAAAAAEG4/iEKlDeI05gs2xyRFhhbFKpYz0cY_Jr_bQCEw/s320/Workspace%2B4%2B-%2B5.png" width="320" /></a></div>
<br />
<br />
<div>
<br /></div>
Raoul's weetjeshttp://www.blogger.com/profile/00421367377469087714noreply@blogger.com0