Teachers

With Workplace 2007, Microsoft company presented entirely new computer file types for Term, Succeed, and PowerPoint. Specific by an x at the end of the computer file expansion (.docx instead of .doc, and so on), these were not in reverse suitable.
Initially, I wasnt satisfied with this modify. Im usually traditional about well-known and recognized computer file formats--especially those reinforced by a great many application venders--and dont want them to be modified. And almost everyone at work application business has been assisting .doc and .xls for years.
But Microsoft company did an outstanding job creating the conversion as easy as possible, and guaranteeing that both the old and the new types would stay understandable. (If anyone believes Im a shill for Microsoft company, I recommend they study Why you should not update to Microsoft windows 8.)
Youll have no problems running an old .doc computer file into a contemporary edition of Term. (Im talking about Term particularly for comfort benefit. Everything I say here also works for Succeed and PowerPoint.) Just double-click the computer file and it will start.
You can also preserve a .doc computer file, so that people using mature editions can study it. In the Save As discussion box, simply choose the Save as pull-down selection and choose Term 97-2003 Records (*.doc).
Previous editions of Term were published without information of the .doc x structure, so you cant anticipate them to study it without a little help. But the help is there. If youre using Workplace 2003 (or even Workplace 2002 or 2000), obtain and set up the Microsoft company Workplace Interface Package for Term, Succeed, and PowerPoint File Formats. Youll be able to start, modify, preserve, and make the more recent x types.
And yes, the more recent types have their benefits For one thing, the information are small, since the x types have loss less pressure developed in. In common, .docx information are about half the dimension .doc information with the same content, and Ive seen some less than a one fourth of the dimension, creating it simpler to email or back-up the information. According to Microsoft company, theyre also more protected and recoverable, although I havent seen proof of this with my own sight.
Theyre also developed to be easily reinforced by other, non-Microsoft applications. In fact, theyre developed up of current, start computer file types. If you dont believe me, try this: Relabel a .docx computer file, modifying the expansion to .zip. Then double-click it.
Yes, a .docx computer file is really a .zip database (I informed you it was compressed). Most of what you find inside are .xml files--another start conventional. That research will also work on .xlsx and .pptx information.
After youre done testing, dont ignore to modify the expansion back to .docx.
Every well-known and effective application consistently produces more recent editions, usually every season in the case of well-known applications. When Microsoft® produces a program of any office program, they provide frequent up-dates so they do not need to launch one every season. When a significant renovation of the Microsoft company Office® Suite happens in which it is more recent, customized, prolonged, and with a more contemporary GUI (which contains the Microsoft® Term written text editor), the changes are not only developed to the program but also include computer file type and structure changes. This is because the new papers types are developed in the same way as the performance of the program. However, problems may happen when trading documents published in mature editions of an program. In the actions below, you can learn how to preserve Microsoft® Term information to be suitable with previously editions.
Instructions:
Start the Microsoft® Term 2010 program.
Open the computer file in which you want to “re save,” or make a new papers.
Click on the “File” tab in the main routing bar.
Choose “Save As” or “Save” for a recently developed papers.
Write the name of the papers in the “File name” box.
From the “Save as type” drop-down, select the preferred edition (usually “Word 97-2003 Document [*.doc]” version).
Click the “Save” key to preserve in an previously edition of Microsoft® Term.

Being crazy of Pentaho and its associated tools Id like to share some thing about Pentaho CE 5.0.1 BA latest release..
First of all, Id like to thank you to the web details team for the efforts they kept in bringing up the powerful analytical engine(BA server).

The home page itself make you to stick with BA server where you can enter into the server with "admin" and "password" as the default credentials.. Yes, "joe" user is no more but he left with the same password to log into BA server.

There will be NO more admin console ... Now it is very easy and developer friendly to navigate in one console(User Console) to give data base connections and new roles for new users..

A lot of stuff included in the home page itself, giving the blogs links, books on different tools of pentaho family. In a single word I can say , All the stuff related to Pentaho at a single place. A BI developer like me can reduce the time for developing reports, dashboards , jobs.

Market place for installing C-Tools and the installed plug-ins list drop down is one of the good ideas of the team.

As quick as Pentaho released its CE 5.0.1 , I just downloaded and trying to explore the new look and navigating from all the menus, reports, connection places and etc.

Its very easy to install the pentaho CE BA now in windows...
Installation procedure :
1) Down load the software as a .zip file using this link .
2) Unzip it in your fav folder
3) Click on start-pantaho.bat file

Home page :


NOTE: path and class path for java must be set before the installation.

This post will talk about basic understanding of parameters concept in PDI.

Software Setup :
PDI 5.1.0 CE
PostgreSQL

Concept : Retrieve data from table by passing table name as parameter.

You will learn below things
1) Table input step & database connections
2) Creating parameter(s) in Transformation(s) & Job(s)
3) Passing parameter(s) from job to transformation.

Lets say in foodmart database you have below tables 1) region 2) product 3) customer and etc.
Every time when you pass different table name as parameter you should able to fetch the data coming from the passed table.

1) Table input step & database connections
2) Creating parameter(s) in Transformation(s) & Job(s)

1) Create a new transformation & drag and drop "Table Input" step from Design Pane.

2) Double Click on "Table input" step & Click on New tab to give database connections as shown in below image


3) Define the parameter in transformation ( in this example the table name should go as parameter).
    Image A : Right Click on the empty space to get the transformation settings.
    Image B : Database Connection Details

    Parameter Name is : tableName


 4) Come back to the properties of "Table input" & write select statement to retrieve the data.
     Eg : SELECT * FROM product LIMIT 100
     In above example "product" is the table name that you have to replace with the parameter.
     i.e., SELECT * FROM ${tableName} LIMIT 100

     Once you write the query, come down check "Replace variables in script"





 5) Take a "Dummy" step and connect it to "Table input step" . Save the transformation & run it on "Dummy Step"( Right click dummy step and click on "Preview".

OUTPUT : Test 1  : With "region" table

OUTPUT : Result 1


OUTPUT : Test 2 : With "product" table
 * Right click Dummy step then click on Preview
 * Click on Configure & then in parameters tab give "product" for tableName value parameter.
OUTPUT : Result 2 



3) Passing parameter(s) from job to transformation
* Crtl+Alt to create a new job
* From the "General" node of Design tab ( Appears left side) drag and drop "Transoformation step".
* Drag and drop "START" step and connect these two as shown in below image.


* Double click on "Transformation" step to set the properties & parameter information.
* Browse for the transformation file and then move to parameters tab
* Click on "Get Parameters" then you can find parameter get apper under Parameter tab.

* Right click on empty canvas of job to get its settings & move to Parameters tab and give parameter name as "tableName" and provide default value.

Save the job and run it.

IMP NOTE :
1) Parameter names in job & transformation should match.
2) You can create n  number of parameters in job but can pass as many you wish.
3) In job design you should take  "START" step to tell the job to start execution from there.
   If you ignore you will get below error ( which took me awhile to solve it for the very first time).


Start of job execution
:A serious error occurred during job execution: 
Couldnt find starting point in this job.
org.pentaho.di.core.exception.KettleJobException: 
Couldnt find starting point in this job.
at org.pentaho.di.job.Job.execute(Job.java:516)
at org.pentaho.di.job.Job.run(Job.java:422)
Spoon - Job has ended.

References : 
1) http://wiki.pentaho.com/display/EAI/Named+Parameters
2) http://diethardsteiner.blogspot.in/2013/07/pentaho-kettle-parameters-and-variables.html
3) http://wiki.pentaho.com/display/EAI/Substituting+variable+references+in+Job+Parameter+values

Hope this helps some one like me  for the first time who is looking for parameters(named) concept :-)


Cheers :-)

:-) Happy New Year - Welcome - 2015 :-)

Here is a small workout on giving access of CUBES, Hierarchies,members to different users based on roles assigned to them.

You may not find what you need exactly in this article but I can say  surely that,  you will get some idea on below topics


1) Creating Users & Roles in the BA Server.
2) Assigning Roles to Users.
3) How BA server will identify the roles created in PSW with the roles in BA Server.
4) Developing a Schema of 2 sample CUBES
5) Scenario on the schema


Software  Setup:
Pentaho BA Server 5.x
PostgreSQL Server 9.x [Food Mart Database]
Pentaho Schema Workbench :3.8.0.0-209
Saiku Analytics : 2.6-PENTAHO5-SNAPSHOT (TRUNK)


Assuming you have initial idea on how to design a sample CUBE..
(For creating sample cubes you can follow this tutorial :
http://pentaho-bi-suite.blogspot.in/2013/12/pentaho-schema-workbench-simple-example.html
)

 Concept : Access Control
Problem Statement : 
1) Give Access of CUBE 1 to User 1 who is assigned with Role 1
       Schema grant, Cube grant, Hierarchy grant, member grant .
2) Give Access of CUBE 2 to User 2 who is assigned with Role 2


Step 1 :  How to built role mapper communication in BA Server for created roles in mondrian ?

• Enable mondrian user/role mapper in pentahoObjects.spring.xml 
• File location : /Pentaho/biserver-ce/pentaho-solutions/system

i.e., Uncomment   below code :

  <!--  This mondrian user/role mapper assumes that roles from the platform also exist in mondrian -->

  <!--
  Disabled by default in 3.5.2. In trunk, this should be enabled.
    -->
   
  <bean id="Mondrian-UserRoleMapper"
        name="Mondrian-One-To-One-UserRoleMapper"
        class="org.pentaho.platform.plugin.action.mondrian.mapper.MondrianOneToOneUserRoleListMapper"
        scope="singleton" />
 
NOTE : If your BA server is already running , just stop and restart it.

Thats it.. Now the Roles assigned in schema will mapped to the roles assigned in BA server.(for users).



Step 2 :  Creating Schema with 2 CUBES
Let us take food-mart database(modelled for multidimensional database) and design below CUBES.

CUBE 1 ---> Sales
CUBE 2----> HR

Cube Design Image is shown below :
Download the schema file here :  Click Me
Open it with your PSW...

The design has the following concepts :
 i) Dimension Usage  : 
Create a dimension outside the CUBES( i.e., Right Click Schema -> Create Dimension) and make use of it in CUBES as Dimension Usage.

(i.e, If 2 CUBES use the same dimension, we need not to create it 2 times. We can create one time and use that dimension which ever the CUBE needs for its specific purpose).

In this example  schema :  I made use of two shared dimensions as Dimension Usage. Those are  Store and Time

ii) Calculated Member(CM).
To calculate the measures.. for example : To find profit in this example.
It will results as a new measure in the output.


Step 3 : How to create Users  & Roles?  
Users :  

• Log-in into your server with Admin/password  first(login as Administrator).
• In BA Server Click on "Administration" from the dropdown Home menu. 
• Create 2 Users as shown in below image.

  
Roles:  
Also create 2 Roles in Manage Roles Tab
Sales User  and
HR User   as shown in below image.

Step 4 : Assign roles to Users
As shown in below image
i) HR user is assigned with "HR user" role.
ii) Sales user is assigned with "Sales user" role.

Scenario : 
CASE1) Give Access to CUBE 1 to User 1 who is assigned with Role1
    i) Schema grant
    ii) CUBE grant
    iii) Hierarchy grant  




Notes : 

• Role Name in PSW should match with the role name in BA Server. 
• Role Creation: In PSW "Sales User" role is created for Sales CUBE.
• Cube Grant: Right click on " Sales User" role and select "Add Cube Grant", give attributes : access =all , Cube=Sales
• Hierarchy Grant: Find below image.

•  Member Grant: access=all , member=[Store].[USA].[CA]
• Another   Member Grant: access=none , member=[Store].[USA].[CA].[Los Angeles]

• USA country in current example is having 3 states, CA,WA,OR.
• Out of these 3 states the access is given to only CA state.
• The cities other othn "Los Angeles" will be displayed with the other member grant. 

Output:
1) login to the BA Server as "Sales" user.
2) New -> Saiku Analytics



CASE2) Give Access of CUBE 2 to User 2 who is assigned with Role2
   
As a demonstration just given CUBE Grant to "HR User".

"HR User" is the role name given in PSW as well role created in BA server.
For this role the user is "HR" in this example. 





References :
1) http://mondrian.pentaho.com/documentation/schema.php#Defining_roles
 
2) http://infocenter.pentaho.com/help/index.jsp?topic=%2Fanalysis_guide%2Ftopic_mondrian_security.html


:-)

Sadakar
BI developer

This post will talk about conditional colours of bars with below like scenarios.

Sample Scenario : 
Print bar color as red when bar value <=2000
Print bar color as green when bar value >2000 and <10000
Print bar color as black when bar value>=10000

Scenario 2 : 
When representing -Ve values on charts .. this kind of representation is preferable. 

Code is Taken from Reference links :


function changeBars(){
var cccOptions = this.chartDefinition;

// For changing extension points, a little more work is required:
var eps = Dashboards.propertiesArrayToObject(cccOptions.extensionPoints);

// add extension points:
eps.bar_fillStyle = function getColor(){
var val = this.scene.vars.value.value;

if(val > 0 && val <= 5000){
return red;
}
else if(val > 5000 && val <= 50000){
return green;
}
else{
return black;
}
};

// Serialize back eps into cccOptions
cccOptions.extensionPoints = Dashboards.objectToPropertiesArray(eps);
}


NOTE : I have tried directly in Extension points but it did not work. 

Sample output 1 : 

References : 

http://translate.google.com/translate?&ie=UTF-8&sl=&tl=en&u=http://www.redopenbi.com/group/ctools/forum/topics/colores-en-bar-chart?commentId=2400100%3AComment%3A103280&xg_source=activity&groupId=2400100%3AGroup%3A73260

OR

http://www.redopenbi.com/group/ctools/forum/topics/colores-en-bar-chart?commentId=2400100%3AComment%3A103280&xg_source=activity&groupId=2400100%3AGroup%3A73260

OR

http://forums.pentaho.com/showthread.php?150582-Bar-chart-colors-dynamically-changed-based-on-data-value-Along-with-JavaScript-vars

Read: switch statement in C - Part 1

In the last tutorial I told you about the syntax and working of a program using switch keyword. Well in day to day programming we generally don’t use that syntax in C. This is because if we use the earlier method then it will execute all the subsequent statements after the condition turns true.

switch statement in C 

So we need a syntax that will execute only a certain set of statements when the condition turns true. So lets checkout the advance modification of switch statement with break keyword.

Syntax

switch(integer expression)
{
case constant 1: Statement 1;
break;

case constant 2; Statement 2;
break;
. . . . . .
. . . . . . 

default: Statement 3;
}

Explanation of the above syntax
Well the whole syntax is almost same. But in the above syntax we have added break keyword after the cases. Remember we generally do not use continue keyword with switch.

Working of break keyword in switch statement
As you can see I have given break keyword after every case. Its working in switch case is almost same as in loops. If the compiler encounters break keyword in switch then it will take the control to the outside of switch block.

Flowchart of switch statement in C - Image Source

The perfect way to understand it is through a program.

#include<stdio.h>

void main()
{
 int i=10;

 switch(i)
 {
  case 1: printf("Hey its 1");
   break;

  case 10: printf("Hey its 10");
    break;

  case 7: printf("Hey its 7");
   break;

  default: printf("Hey its default");
 }
}

Output


Explanation 

• In the beginning of the program I have declared an integer variable with value 10.
• After that I have written switch keyword with integer expression i. It means the compiler will check the value of i (which is 10) with all the cases.
• In the first case I have written integer constant ‘1’ which turns false. So compiler will skip that case.
• In the second case I have written integer constant ‘10’ which turns true. So compiler will execute the statements under that case.
• Now just after the printf() function I have written a break keyword. So it will take the control of the program outside the switch block.

Points to remember

• You can also write multiple statements under each case to execute them. And you will not need to give separate braces for them, as the switch statement executes all statements once the condition turns true.
• Remember default keyword is optional. Its completely depend on us whether we want it or not in our program.
• The order of cases and default in the switch block do no matter. You can write them in any order but you must take care of proper use of break after each case.