Saturday, March 10, 2012

Input Controls in Business Objects

Topic: Input Controls intro in Web Intelligence reports of Business Objects XIR 3.1 and how you can create Xcelsius like Dashboards with Input Controls!

Video walkthrough: Traditionally until 3.1, we had to ability to add Query Filters and in report Report Filters to see partial or granular data. For example, if users asked for the ability to pick and choose States, individual or multiple, you'd build a state Prompt for them and they would have to Refresh the (WebI) report EVERY TIME to pick new states of their choice and hit RUN. This was very ad-hoc like interactive approach because they wouldn't have to ask for a developer's assistance to dissect the report and see granular information. But, every refresh takes some toll on your DB server. Not all reports run in seconds, many takes minutes; multiply that by hundreds or thousands of users, they waste countless hours, DAILY!

Creating Xcelsius like Dashboards with Input Controls!
That's when Input Controls come in. You no longer need to add a prompt. Simply get rid of the prompt (assuming this is a report with reasonable data; not thousands of pages) and add input control for that prompt dimension. You refresh the report once, and once all the data is available, simply use the input controls to dynamically pick and choose and select as many or few states, years, products, or any other dimensions you'd like to view your data based off of. Let's look at it in action with our video below.

Tuesday, January 31, 2012

MicroStrategy offering Free Classes around the Globe

MicroStrategy, a well known BI platform. They are offering few introductory classes from January 31st, 2012 to March 30th, 2012 in many places throughout the USA and across many other countries including Argentina, Australia, Belgium, Brazil, Canada, France, Italy, Japan, Mexico, New Zealand, Poland, Portugal, Singapore, South Korea, Spain, Sweden, United Kingdom, United States. Try one out!

Three Great Classes, One Amazing Series

Introductory Workshops for Business and IT in a Location Near You

"Extraordinary businesses are built from extraordinary decisions. These decisions depend on the data driving them. MicroStrategy software transforms your data and empowers your business to make informed, insightful and profitable decisions. MicroStrategy's new Business Intelligence Workshop Series comprises three free, one-day hands-on workshops introducing BI from the perspective of a business user, IT developer, and mobile user."

Introduction to Enterprise BI

Friday, December 23, 2011

Tableau 7 World Tour sign up

Tableau is a very smart Business Intelligence Dashboard and Analytics application that connects to all your data sources and displays the data in a very visually appealing fashion; much like Xcelsius. Tableau allows users to publish and collaborate content with others including dashboards, interactive reports, charts, what if analysis and more on your intranet or on the web, securely.

They are having a tour across the USA and several international locations next month, January 2012. If you are near any of these locations, you may want to attend to explore Tableau hands on.


Saturday, December 10, 2011

Globally change user preferences in BO 3.1

Topic: How to globally change users' preferences in Business Objects 3.1

When we log into Business Objects 3.1 Infoview, by default we are brought to the Navigate/Personalize window. Then from here we need to click on Document List, My Favorites and so on, to go where we need to go. So, if a user belongs to Accounting department for example and only has access to Accounting folder, he/she needs to click on Document List and then Accounting folder, every time he logs into Infoview. Now, if all 50 Accounting employees need to do this several times a day, every day, it becomes cumbersome and valuable time is lost.

This video will walk you through on how to globally set preferences for individual groups and redirect to unique locations; e.g. Accounting group to Accounting folder, Marketing group to their inboxes and so on.

Friday, April 29, 2011

SQL Basics in 30 Minutes - Part 3

Topic: SQL Basics in 30 Minutes - Part 3: Views and Stored Procedures. 

Views, just like the word word itself, is a part of a whole. Look at the image on the left. You can see a partial 'view' of the earth. You don't see the rest of the earth, though it exists. Just like that, a View can have columns that are not seen, i.e. hidden from users. For example, you may have a table called "Credit_Card" and that table may contain the following columns: First_Name, Last_Name, Credit_Card_Number, Last_4_Digit, Address and so on. For security purposes, you (or your company) may only allow developers to create a View called "Credit_Card_Public" that may only have the following columns: Last_Name, Address and Last_4_Digit (of the card). 

Stored Procedures, again, just like the name suggests, are procedures or SQL commands that are stored in a single object. Look at the rabbit pic at the left. Think of the rabbit as a Stored Proc. As soon as you signal the rabbit, it snaps the twig and boom; all those bundles of cash start a domino effect leading up to the last bundle. Similarly, when a Stored Procedure is executed, series of SQL commands get run, leading up to the the 'end' of the stored proc. 

Tuesday, April 26, 2011

50 Percent off all SAP Certification Exams

Stand out with SAP certification
50% off before June 30 2011
SAP gives you edge. Register now for 50% off all exams taken by June 30 at Pearson VUE venus across US and Canada. Enter promortional code: 11CERTTL
There's nothing like SAP certification to give you prestige in the business world.

With a 50% discount on all exams till June 30, now is the time take your career to new heights.
SAP certification shows that you're a cut above the competition.

People who are SAP certified stand out because they've honed their skills through rigorous study and real-world experience. They've proved their worth by passing demanding exams.
Want this kind of recognition?

Register now for 50% off all certification exams taken by June 30 2011 at Pearson VUE venues across the US and Canada. Simply select your certification exam and Pearson VUE venue then enter the promotional code: 11CERTTL

More information
Visit the SAP Training Shop

for more information on SAP
certification and search by
exam, solution or focus area.