BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« Pre-packaged dashboards or ad-hoc analysis: what's the best ? | Main

December 13, 2010

Bime Tip: Decompose, Drill Through and Focus features

In the new version of Bime, you can use the Decompose, the Drill-Through & the Focus features. Here's a quick tutorial on how each one works.


If you choose to decompose then you can analyze data using a different axis (i.e. a different attribute).

The cartesian and pie charts allow you to 'decompose' your visualization, both on queries and on dashboards (if allowed in the dashboard preferences). Click on a data range and a pop-up appears, offering you this option. Click, and you can select to which attribute you want to dig down into.

For example, this pie chart shows results based on one attribute (here, 'Year(Ship Date)') - but you can focus in on one element of that (here '2005') by using decompose.

Having opted to decompose using 'Sales Channel', the chart changes to show results only by the chosen Year, which has been moved to be a filter.

You can continue to 'pivot' your data by altering the filter. Alternatively, decompose another segment of the pie and each new view adds that segment's attribute to 'filters', enabling it to focus in on that segment, and uses the new chosen attribute in 'columns'.

Thus, decompose allows you either to drill down into the detail, or 'flip' the visualization from being defined by one attribute to another.

Drill through

If you choose to drill through then you can visualize the underlying data in each query.

In the pivot table, you can use the Drill Through feature on cartesian and pie charts to see underlying data for a selection of data points, displayed as detailed lines. For instance, the following figure illustrates the result of a query for which we visualize the Shipping Cost per Region. Let us imagine you want to see the underlying data for the Region Central. To do this, click on the Central horizontal bar and then click on the Drill Through item.

Once you click on Drill-Through for selected data points, Bime retrieves & computes all the underlying data and displays them in the Drill-Though pop-up illustrated by the image just below. In our current example, the Drill-Through operation has retrieved 2100 underlying lines (i.e. 21 pages of 100 lines). Consequently, keep in mind that the more numerous the underlying data are, the longer the Drill-Though computation time.

In the Drill-Through pop-up, you can navigate through the underlying data with the 'Next' & 'Previous' page buttons, visualize a specific page directly through setting the index of the wanted page in the numeric stepper, and exporting the underlying data as an CSV file through clicking on 'CSV'. In addition, you can modify the number of lines which are displayed per page. Then, click on 'OK' to close the drill-though pop-up.

To conclude, please note that the Drill-Through feature is available only on in-memory & RDBMS connections.


If you choose to use focus then you can restrict and execute an original query of the dashboard only for elements you have selected.

In the pivot table, the focus feature is a shortcut to filter elements visually. As illustrated in the following figure, let us imagine we are analyzing the profits we realize per customer segments.

Let us imagine now that we want to restrict our analysis to the Corporate & the Home Office customer segments. For this, we have only to multi-select Corporate & Home Office, and then click 'Focus on selection'.

As a result, the current result is restrict for Corporate and Home Office, as illustrated by the following figure.

Posted by We Are Cloud at December 13, 2010 8:15 AM


Hey this post is a little good. Can you reply me any related articles?

Posted by: Sportster Exhaust at December 15, 2010 6:29 AM

Apple now has Rhapsody as an app, which is a great start, but it is currently hampered by the inability to store locally on your iPod, and has a dismal 64kbps bit rate. If this changes, then it will somewhat negate this advantage for the Zune, but the 10 songs per month will still be a big plus in Zune Pass' favor.

Posted by: Brittny Engleby at January 23, 2011 4:52 PM

Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.

Posted by: najlepszy seo hosting at February 10, 2011 4:26 AM

Valued at approximately $5 million, it perhaps can be best described as 16,000 square feet of paradise. The rear of the Chateau houses two "prayer gardens," a man-made waterfall, tennis court, amphitheater and a negative-edge pool that offers the illusion of crystal blue waters flowing into a stream.

Posted by: Kisha Needy at February 11, 2011 2:35 AM

I was very excited to find this site.I wanted to thank you for this great writings! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post.

Posted by: Tibetan Jewelry at February 20, 2011 9:36 PM

The guidelines you contributed here are really valuable. Rrt had been such a pleasurable surprise to get that waiting for me when I woke up today. They are usually to the point and straightforward to grasp. Thank you very much for the innovative ideas you have shared above.

Posted by: zero friction marketing at February 25, 2011 5:24 PM

Ah just have fun as my friend Brendan Fohl play only free games in your free time.

Posted by: Willena Adule at February 25, 2011 5:45 PM

There is always a light at the end of the tunnel.

Posted by: TADALIS at February 26, 2011 1:23 AM

Usually I do not post on blogs, but I would like to say that this article really forced me to do so! Thanks, really nice article.

Posted by: Teresa Polle at March 2, 2011 2:01 AM

protracted daybook you get hold of

Posted by: Wade Lapadula at March 2, 2011 8:25 PM

Hello! this site of your blog was very helpful for me. But it was difficult to find it with ask. Maybe you should improve it with wordpress plugins for wordpress like WP seo. Just a tip ;) (:

Posted by: Buck Shrewsberry at March 9, 2011 1:07 PM

magnificent points altogether, you just gained a brand new reader. What would you recommend in regards to your post that you made some days ago? Any positive?

Posted by: Nakia Gearing at March 15, 2011 5:01 AM

This makes a lot of sense but its

Posted by: Beach Wallpaper at March 21, 2011 11:26 AM

This makes a lot of sense but its

Posted by: Dark Art Wallpapers at March 21, 2011 11:23 PM

This web page can be a walk-via for the entire info you wanted about this and didn’t know who to ask. Glimpse right here, and also you’ll positively uncover it.

Posted by: naprawa sterownika pompy at April 3, 2011 11:45 AM

I took 1 st loans when I was 32 and it supported my family very much. Nevertheless, I need the credit loan once more time.

Posted by: Veronica25Marshall at April 4, 2011 2:48 AM

This is very advice. I have to say I enjoy reading this article a lot. It helps me to turn into better grasping about the subject. It is very well produced. I will definitely get this specific content material very engaging. I hope you are able to provide more sooner or later.

Posted by: google fast cash review at April 8, 2011 4:55 AM

This is often i will be attempting to find. This I call quality. The information provided in here is usually to the most. I must say you will require spent some time in making each one of these content together. They're matched with your topic. I am going to recommend this to all and also to all my friends. I am going to return here to try out the quantity of work. I appreciate you for building this take place.

Posted by: online fast cash loans at April 17, 2011 11:31 PM

This can be i'm attempting to find. This I refer to valuable. The information provided in this article will be to the most successful. I must say you need to have spent your time in making every one of these content collectively. They're match with your market. I'll suggest this kind of to the world and then to every single piece of my friends. I'll come back here to examine how much give good results. Thank you for producing this transpire.

Posted by: ultrasonic flaw detector manufacturer at April 26, 2011 5:29 AM

This can be i will be in search of. This is what I call quality. The knowledge provided right here is usually to the best. I would like say you must have bought some time in setting each one of these content together. They are matched with your theme. I shall endorse this kind of to everyone and then to all of my associates. I'll get back here to check out how much function. Appreciate making this specific take place.

Posted by: ultrasonic flaw detector manufacturer at April 26, 2011 7:51 PM

This is i am in search of. This I call high quality. The data provided right here will be to the best. I must say you must have spent some time in making every one of these material collectively. They're related to your theme. I shall endorse this to all and then to each one of my buddies. I shall go back here to experiment how much function. Appreciate generating this kind of ensue.

Posted by: ut flaw detector at April 26, 2011 10:25 PM

This is often i will be in search of. That is what I refer to as valuable. The information provided right here will be to the best. I need to say you need to have spent some time in setting each one of these content material jointly. They're related to your product. I am going to suggest this specific to the world and all my friends. I will come back here to examine the quality of function. Appreciate producing this take place.

Posted by: ayurveda tour packages india at April 27, 2011 8:14 AM

This is i am attempting to find. That is what I refer to as quality. The information provided in this article is to the greatest. I must say you will need bought a while in making all these satisfied collectively. They're related to your market. I'll suggest this specific to all and all of my associates. I shall get back here to check out the quantity of give good results. Thank you for building these take place.

Posted by: Data Recovery Service at May 2, 2011 2:22 AM

I just want to say I'm newbie to blogging and actually savored this page. More than likely I’m going to bookmark your blog . You absolutely come with good article content. Cheers for sharing your web page.

Posted by: go to this web-site at December 17, 2016 3:31 AM

Post a comment

Remember Me?