Implement your Master Data Management (MDM) System Risk Free.

Having a Master Data Management  system is the first crtical step organizations must  take to improve the quality , accuracy and timeliness of business information. in order to make better business decisions.

An MDM system will create company wide standards for the naming entities and categories and their important attributes, that your business uses. (See Definitions and Screen Shots in the side bar opposite to see how Dimension Manager displays Dimensions, Hierarchies, Entities, Categories and Attributes.)

Once you have this company  master data defined and the meanings agreed and standardized  in a centralized location, you get your IT department to use these standardized definitions for ALL your corporate systems.

These could be transactional Order Entry, Stock Control  and other ERP systems, Reporting & Planning Systems, data warehouses and Business Intelligence Systems.

An MDM system will prevent the creation of duplicate categories, it will guarantee the integrity and validity of all you internal business reporting and  operations as well as those of your suppliers and customers.

Many Master Data Management implementations have price tags in the tens of thousands dollars. Often you are paying for functionality that is not required. 

Dimension Manager easily manages your main business hierarchies, categories and key attributes for your company reporting, data warehouse or business intelligence systems.  Most companies will get a huge benefit by doing this in simple and straight forward way. 

That is what Dimension Manager is. A simple, straight forward, practical way to centrally manage key master data and Dimensions  for businesses of all types large and small. In many cases your business will not require anything more complicated.

If your business does require a more complex solution then we will happily recommend other products to cover off your requirements. However, just remember, if you can't get a benefit managing your key Master Data then you are unlikely to gain much implementing a more comprehensive solution.

Dimension Manager Features

• Uses a File Manager like interface to move (drag and drop) categories to the correct location.
• New categories appear in the orphan categories section. These then be easily moved to the correct parent.
• Guarantees master data integrity.
• Enforces company business rules and relationships.
• Multi user secure access to all dimensions, individual levels categories and attribute data.
• Integrates directly to the corporate data-warehouse or reporting system.
• Allows a company to manage its products, customers, accounts, calendars and any other important master data in the one place.
• Contains full audit control and rollback functionality.
• Manages hierarchies with thousands of categories and attributes.
• Dimension Manager can be automated to flag new categories coming from company transactional systems. (Accounting, Order Entry etc)
• Maintain attribute information; text, date, numeric or coded list data for any category.
• Open data base structure . Your IT department can create its own database views and scripts to support your other business applications.
• Very stable application so clients log very few incidents.

Dimension Manager Benefits.

• Enforces a companywide standard on naming and defining important key entities and categories. This is critical to the success of all business reporting, data warehousing and business intelligence projects.
• Allows users to quickly create alternate reporting structures not found in order entry and accounting systems. Save on costly modifications to these systems.
• Eliminates the time spent by short staffed IT & BI departments in resolving hierarchy issues. Pushes responsibility for master data and hierarchies back to the business where it belongs.
• Guarantees integrity of hierarchy data. Ensures accuracy of Company reports and reduces Cube (Business Intelligence databases) build times.
• Generates structure and master data for with the company reporting system or data-warehouse. Including Cognos, SAP BW, MS Analysis Services and Reporting Services.

Why Companies Can Benefit From Using MDM's Dimension Manager.

Dimension Manager can manage an unlimited number of hierarchies and entities  with thousands of categories. It can also support hundreds of attributes for those categories.  

Dimension Manager is ideally suited to  mid size companies( 50 to 500 employees) that  need to manage all their important hierarchies, entities  and reportng categories. If each category has less than 20 attributes then Dimension Manager can easily manage this problem, and your company will gain significant  benefits.

Dimension Manager does not have a formal workflow function which is often needed when managing  more than 40  attributes per category, so if this is important then Dimension Manager may not be the correct solution.

Businesses use Dimension Manager to manage Charts of Accounts, Cost Centre Structures, Customer Structures, Product Structures, Special Business Calendars. In fact, any business data that need to formally defined and managed by key business users.

Dimension Manager has been used by consumer products ,beverage,  financial services, retail  and pharmaceutical companies. Some companies use Dimension Manager to manage all their master data, while others only manage selected data. For example one company uses Dimension Manager to manage Product Hierarchies and Account hierarchies and attributes. It uses a dedicated  CRM system to manage its customer information.

Here are two ways you can get master data management into your business.

Implement your Company Master Data Management system for $5000 Risk Free.

This Risk free price includes :

• 8 Years Experience in Master Data Implementations. Dimension Manager was written in 2000 before the term Master Data Management  was in common use.
• MDMs Dimension Manager Enterprise Unlimited User License that runs on MS Sql Server. Value $5000. (Sql Server Database not included)
• 5 Days consulting free to implement Reporting structures fully Integrated with your business Intelligence or Data Warehouse or Reporting Solution.  Value $6000 Allow 1  to 2 days for each structure..
• Technical Staff Training  Value $2000
• User Training Value $1000
• A total of $US14,000 products and services for $US5000.
• Secure Remote Installation. We don't need to visit your company. We install and configure solution over the internet using logmein.com  and a phone.
• Secure Remote Response to any Issues. Next day guaranteed.
• 100% Money Back Guarantee and Risk Free Implementation. If Dimension Manager does not do what you thought it would do you don't pay a cent. We use escrow.com to manage payments so funds are only released to us on your approval..

or Get Dimension Manager Installed and Integrated for Free** by Asking  us to Implement your New Business Intelligence System 

If your company does not have a Business Intelligence System, and you would like a risk free way to implement one,  ask us to implement one for you,  When you purchase our  Business Intelligence solutions  you will get to use Dimension Manager Enterprise for one year for free. 

We have been implementing Business Intelligence systems of 11 years so we know that Master Data Management  is key to the success of any Business Intelligence System.  

So if you are serious about Master Data Management for your Business you had better register your interest here without obligation. You will recieve our  free report about how to implement Master Data Management  and  Business Intelligence  to improve the quality, accuracy and timeliness of you business infromation right into you inbox..

MDM's Dimension Manager.

Business's rely more and more on sophisticated reporting and analytical tools. These sizable investments value can be significantly reduced unless company master data and structure data (report category rollups) are carefully managed.

Examples of  master data 'Dimensions'  are.:

• Brands and Products and Product Attribute size, color, Type etc
• GL Charts of accounts and account roll ups.
• Customers, Territories  and Sales People.
• Cost Centers and Locations
• Business Calendars

An Example of Hierarchies within  a  Dimension are Business Calendars:

• 544 weeks per Quarter ,
• 445 Weeks per Quarter, 
• Accounting Years and Months Days for Financial Year or  Calendar Year
•  Year to Date March YTD, September YTD.

An example of Entities are: 

• Product Category (Roll up or Total Level)
• Product  (Roll up or Total  Level)
• SKU (Base or Leaf Level)
• Account (Base or Leaf Level),
• Account Level 3,  (Rollup or Total  Level )
• Location (Base of Leaf Level)
• City (Rollup or Total Level)

An Example of Categories are:

• Whole Foods (Product Category)
• Basmati Rice (Product)
• Basmati White  Rice 1 lb or 500 g (Sku)
• 6004 Print Advertising  Expenses (Account)
• 600 Advertising  Expenses (Account Level 3)
• La Jola CA, Birmingham UK  (City or Total Level)

An Example of Attributes are:

• Size - 1 lb or 500gm  (Attribute of SKU)
• Color-  White  (Attribute of SKU )
• Dangerous Goods Classification  None - (Attribute of Product)
• Account Type (Asset, Liability ,Income ,Expense)  (Attribute of Account)

Having different sources for product, customer and financial master data can cause incorrect totals on company reports and can lead to poor business decisions.

The following examples highlight the importance of managing and maintaining company master and hierarchy data.

• Brands can have different lists of products between departments. That is, the Logistics' Brand X is different from Sales' Brand X. What happens when the two departments discuss the sales forecast? When Sales say we need 10,000 units of Brand X. Logistics could potentially source the wrong products.
• Often financial reports need to be structured differently when reporting to head office. These extra account groupings are often created using Excel "lookups" which is prone to inaccuracy and lots of manual checking. Dimension Manager can be used to create many alternate account groupings for different target audiences. These alternate hierarchies are then loaded into the company reporting systems to generate the required information. The company does not have to modify its existing accounting system to do this.
• Sales Territories are always being restructured. This makes reporting and managing them difficult. A central place to manage customer information and sales areas makes it easy for the reporting systems to restate targets and actual sales by territory. Dimension Manager can easily map different customers to sales regions and export this information to the company reporting system. If you don't have a CRM system this can be an easy way to maintain key customer information.
• Products and Customers with incorrect parent categories can lead the company reports to double count or give incorrect report information. How would this problem impact your business?
• What is the implication for your business if you tell customers and suppliers incorrect information about your products? What happens if your products have incorrect units per case, dangerous goods classification or weight information?

Dimension Manager Screen Shots.