We just got bigger and better! Visit our new website DWBI.org →
Our community is shifted to a new home. And guess what - You will love it there!

Join the Community


Free BI Digest

Need more help on this subject?

  • A vibrant community of data warehousing and business intelligence professionals
  • Huge collection of tutorials, technical articles and white papers available freely for your study
  • More than 50,000 registered members
DWBI Community

DWBI Knowledge Base


Start with Database. A set of articles that teach you basic concepts of database in general


Extraction, Transformation and Loading (ETL) is often an intermediate step to process data for data warehouse

Data Warehousing

Data Warehouses are built as a non-volatile storage of data for the purpose of trend-analysis, prediction and reporting


Business intelligence is derived by appropriate analysis of data stored in data warehouses and data marts


A fine collection of articles and tutorials for the data warehousing professionals


Got a technical question on any tools or technologies related to data warehousing? Ask here.

Get yourself a BI Certification

Pass this certification and we guarantee any other BI/DW exam will be a piece of cake for you. Make no mistake, this is the certification that really "teach" you the hard way - you can't get it done by just memorizing a few answers.







Acquire indepth knowledge in Data warehousing and business intelligence Prepare yourself with the state-of-the-art technologies in the field of business intelligence Certify yourself as a data warehousing and business intelligence professional
Love DW/BI? Prove it! Become a DWBI Certified Professional (DBCP) > >

DWBI Forum Rule

Welcome to DWBIConcepts' forum - The best forum to ask your questions related to data warehousing technology.

In order to make your stay as pleasant and constructive as possible please take your time to read through this document, it will help you navigate the pits and traps this community has created for new members ;) These rules can be changed without notice though normally we announce changes via announcement in all the forums.

  1. Read up before asking! There are tons of guides, whitepapers etc. in the main site [www.dwbiconcepts.com] that may already contain the answer of your question.
    • Use the search function before posting. Chances are your question has already been answered.
  2. Respect the netiquette: Lurk and get to know the forum before you post.
  3. Keep the focus: Questions outside the scope of a certain forum will either be moved, locked or simply be deleted.
  4. Be nice to each other and respect the moderator. Profanity and insults will not be tolerated. If you have a problem with another member turn to the respective moderator and if the moderator can't help you send a private message to user [akash].
  5. Do not spam. No blatant advertising.
  6. No warez, cracks, serials or illegally obtained copyrighted content! Links to content of a questionable nature (e.g. anything you don't own and/or have downloaded), asking for, offering, or asking for help/helping to process such content in any way or form is not tolerated.
  7. Keep the size of personal images down.
  8. No cross posting. Post your message once, to the appropriate forum and nowhere else or it will be locked or deleted without warning.
  9. Use a title that describes the content of your post. Don't use all caps or special characters to draw attention.
  10. Do not send questions pertaining to topics of discussion on this board via personal messages or email to Moderators or Admins, they will be ignored.
  11. Don't post just to increase your number of posts. If you have nothing to say on a certain matter then don't post. The number of posts on this board has no direct relation to the experience of a member.
  12. The official language is English. Outside the translator forum English is the only allowed language.
  13. Multiple registrations are prohibited and are grounds for immediate account deletion.
  14. Instructions by the moderator team are to be followed.
  15. No discussion about the rules or their interpretation.

The interpretation of these rules is solely up to the owner of this forum and can change at any time without prior notice. If you're unsure about what constitutes a breach of a rule, ask a member of the moderator squad or refer to the most recent precedent in the forum (though since interpretation can change, we cannot guarantee that any precedent you may find still applies so in order to be on the safe side, ask a moderator if the precedent still applies).

By posting to this forum you indicate that you comply to the above rules.

A Comprehensive website for DWBI Professionals

Data warehouse Technology is relatively new. The need of data warehousing comes from an organization’s growing demand on reliable, consolidated and integrated reporting and analysis of its data for informed decision making. In the recent years, owing to the huge growth of hardware capacity, processing power and relatively cheap data storage solutions, the field of data warehousing has expanded appreciably.

Now-a-days, almost all the biggest names of every business domain in Retail, Banking, Healthcare, Telecom, Insurance, Manufacturing, Logistics etc. use data warehouse. This has been possible due to the relentless hard work and impervious dedication by a group of IT professionals who are coding the backbone of data warehouses around the world.

This site is dedicated to them!

Terms & Condition

Website usage terms and conditions

Welcome to my website, www.dwbiconcepts.com. If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use, which together with our privacy policy govern www.dwbiconcepts.com’s relationship with you in relation to this website.

The term ‘www.dwbiconcepts.com’ or ‘us’ or ‘we’ refers to the owner of the website whose office is situated at Arabinda Nagar East, Jalpaiguri WB, India. Our company registration number is applied for and will soon be published. The term ‘you’ refers to the user or viewer of our website.

The use of this website is subject to the following terms of use:

  1. The content of the pages of this website is for your general information and use only. It is subject to change without notice.
  2. Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.
  3. Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific requirements.
  4. This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.
  5. All trademarks reproduced in this website, which are not the property of, or licensed to the operator, are acknowledged on the website.
  6. Unauthorised use of this website may give rise to a claim for damages and/or be a criminal offence.
  7. From time to time this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s).
  8. Your use of this website and any dispute arising out of such use of the website is subject to the laws of India.

Conditional Column Hiding in BO 4.0

I had earlier posted about column hiding in BO 3.1 using Alerters. BO 4.0 offers a more flexible means of column hiding. This is actually a component hiding feature that works for table/chart etc.

Read more: Conditional Column Hiding in BO 4.0

Privacy Policy

What information do we collect?

We collect information from you when you register on our site, place an order, subscribe to our newsletter, respond to a survey or fill out a form.

When ordering or registering on our site, as appropriate, you may be asked to enter your: name, e-mail address, mailing address, phone number or credit card information. You may, however, visit our site anonymously.

Please take note that any third party may be placing and reading cookies on our users' browsers, or using web beacons to collect information as a result of ad serving on our website.

Google, as a third party vendor, uses cookies to serve ads on our website. Google's use of the cookie technology enables it to serve ads to website users based on their visit to our sites and other sites on the Internet. Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy.

What do we use your information for?

Any of the information we collect from you may be used in one of the following ways:

  • To personalize your experience(your information helps us to better respond to your individual needs)
  • To improve our website (we continually strive to improve our website offerings based on the information and feedback we receive from you)
  • To process transactions
    Your information, whether public or private, will not be sold, exchanged, transferred, or given to any other company for any reason whatsoever, without your consent, other than for the express purpose of delivering the purchased product or service requested.
  • To administer a contest, promotion, survey or other site feature
  • To send periodic emails
    The email address you provide for order processing, will only be used to send you information and updates pertaining to your order.
    If you decide to opt-in to our mailing list, you will receive emails that may include company news, updates, related product or service information, etc.

Note: If at any time you would like to unsubscribe from receiving future emails, we include detailed unsubscribe instructions at the bottom of each email.

How do we protect your information?

We implement a variety of security measures to maintain the safety of your personal information when you place an order or access your personal information.

Do we use cookies?

Yes (Cookies are small files that a site or its service provider transfers to your computers hard drive through your Web browser (if you allow) that enables the sites or service providers systems to recognize your browser and capture and remember certain information

We use cookies to understand and save your preferences for future visits and compile aggregate data about site traffic and site interaction so that we can offer better site experiences and tools in the future.

Do we disclose any information to outside parties?

We do not sell, trade, or otherwise transfer to outside parties your personally identifiable information. This does not include trusted third parties who assist us in operating our website, conducting our business, or servicing you, so long as those parties agree to keep this information confidential. We may also release your information when we believe release is appropriate to comply with the law, enforce our site policies, or protect ours or others rights, property, or safety. However, non-personally identifiable visitor information may be provided to other parties for marketing, advertising, or other uses.

California Online Privacy Protection Act Compliance

Because we value your privacy we have taken the necessary precautions to be in compliance with the California Online Privacy Protection Act. We therefore will not distribute your personal information to outside parties without your consent.

As part of the California Online Privacy Protection Act, all users of our site may make any changes to their information at anytime (except date of birth, gender and name) by logging into their control panel and going to the 'Edit Profile' page.

Childrens Online Privacy Protection Act Compliance

We are in compliance with the requirements of COPPA (Childrens Online Privacy Protection Act), we do not collect any information from anyone under 13 years of age. Our website, products and services are all directed to people who are at least 13 years old or older.

Online Privacy Policy Only

This online privacy policy applies only to information collected through our website and not to information collected offline.

Terms and Conditions

Please also visit our Terms and Conditions section establishing the use, disclaimers, and limitations of liability governing the use of our website Terms and Conditions given at the bottom of website pages.

Your Consent

By using our site, you consent to this privacy policy.

Changes to our Privacy Policy

If we decide to change our privacy policy, we will post those changes on this page, and/or update the Privacy Policy modification date below.

This policy was last modified on 06 December, 2011

Contacting Us

If there are any questions regarding this privacy policy you may contact us using the information below.

Write to Us: enquire@dwbiconcepts.com
Or, Call us: +65 8588 7636

New Features of BO 4.0 WEBI

BO 4.0 provides a lot of exciting new features. Here we will take a look into the important new features of Web Intelligence Reports.

Read more: New Features of BO 4.0 WEBI

sharing is caring

Get Recognised By

Publishing your technical writings with us

We all started as a beginner in the field of data warehousing. We tried hard to learn, evolve and gain knowledge. Sometimes we tasted the sweet success, sometimes we goofed-up badly. But we kept going. And day by day we became a better engineer than we were the day before.

When others saw you to falter, we saw you gaining experience
Share this experience with us today

DWBIConcepts Call for Paper 2013

Send to us your original writing on any topic covering concepts, utilities or tools related to Data warehousing and Business Intelligence domain. Best entries will be published in the website and contributors will be featured in DWBIConcepts Authorship Profiles.

Email us: enquire@dwbiconcepts.com

Gain visibility as a professional in the BI & DW Field. Contact us to know rule of submission

It doesn't matter how big or how small is your write-up. The only thing that matters is originality. Write anything that you believe is worth sharing to greater BI community. Share your knowledge with other professionals and build a better professional network. Sharing is caring!

Email us: enquire@dwbiconcepts.com

Conditional Column Hiding in BO 3.1 Webi Report Followup Post

Since my last post, I have been asked by people about how would I be hiding a column conditionally when it is not the rightmost column of the table, rather is in the middle.

Read more: Conditional Column Hiding in BO 3.1 Webi Report Followup Post


  • Uncategorised
  • Reporting & Analysis

    Reporting and Data Analytics

    Fundamental concepts related to Data Reporting, Presentation and Data Analytics are described under this section
    • Business Objects
      Reporting Business Objects

      This section contains a number of articles and tutorials on SAP Business Objects™ Reporting tool.

  • DWBI

    Data Warehousing and Business Intelligence

    Fundamental concepts related to data warehousing and business intelligence such as, concepts of dimensional data modeling, data mining, knowledge discovery as well as functional details of BI project management are covered in this section
    • DWBI Basic Concepts
      Data Warehousing Concepts

      This section deals with the fundamental concepts of Data warehousing that every DW professionals must know.

    • Data Modelling
      Data Modeling

      Data modeling is a process used to define and analyze data requirements needed to support the business processes

    • Data Mining
      Data Mining Concepts

      In this sub-category we discuss about Data Mining. Data Mining is an interdisciplinary subject that deals with the method and apparatus of knowledge discovery from the raw data.

    • DWBI Project Management

      Project management is the discipline of planning, organizing, securing, and managing resources to achieve specific goals. A proper management of data warehousing project may lead to successful implementation whereas lousy project management can cause the project to fail inspite of best technical resources.

  • ETL

    Extraction, Transformation and Loading (ETL)

    Fundamental concepts related to ETL Design, features, capabilities and How-Tos related to various ETL Tools are covered under this section
    • ETL Concepts
      ETL Concepts

      Tutorials on the basic concepts and theories behind ETL (Extraction, Transformation and Loading) technology.

    • ETL Design Pattern

      ETL Design Pattern is a framework of generally reusable solution to the commonly occurring problems during Extraction, Transformation and Loading (ETL) activities of data in a data warehousing environment.

    • ETL Informatica
      ETL Informatica

      This section contains a number of articles and tutorials on Informatica PowerCenter™ and PowerMart™ ETL tool.

    • ETL BODS
      SAP BusinessObjects Data Services

      SAP BusinessObjects Data Services provides a single enterprise class solution for data integration, data quality, data profiling, and text analysis. Learn more about SAP BODS here

    • ETL SSIS
      ETL SSIS

      This section contains a number of articles and tutorials on Microsoft SQL Server Integration Services. SSIS is a platform for data integration and workflow applications.

  • Database
    All articles related to Databases.

    • Database Basic Concepts
      Database Basic Concepts

      This is a Subcategory of Database. All the articles in the category are related to the fundamentals of Database starting from ACID property, Normalisation to Advanced topic.

    • Database Oracle
      Oracle Tutorial

      This section contains various Oracle database related articles, tutorials and white papers covering a wide range of areas starting from Oracle architecture to performance tuning

    • Database SAP HANA
      HANA Tutorial

      High-Performance Analytic Appliance is an In-Memory Relational Database from SAP. This is the next wave of In-Memory Computing Technology providing faster, smarter decisions with real-time insights.

    • SQL
      This is a Subcategory of Database. All the articles in the category are related to Structured Query Language of RDBMS.

  • Tutorial
    All articles related to DWBI Tutorials.

    • Interview Questions
      Data Warehousing Interview

      This is a Subcategory of DWBI Tutorial. All the articles are related to Interview specific Questons and Answers.