Data Warehouse

Business Central/NAV Developers Forum
1

Does anyone have experience with SSAS and NAV. Specifically how to set up the cubes so reports can be generated from all NAV companies for better BI? I was looking into Jet Enterprise that ships with 6 cubes. any information would be greatly appreciated

2

Hi Sean,

I can give you a few hints. You can easily solve multi company problems by using proper BI solution - Data warehouse

Why DWH:

Because you can map up different chart of accounts

· Bring in other sources,

· You can do a proper consolidation over multi companies

· Have proper trend analysis over items, companies…

· …

Taking in consideration you are using dwh:

· It helps a lot if you have common item, customer… codes over all or your companies. This will enable you proper item, customer… analysis over multiple companies.

I can show you how we solved it with BI4Dynamics. You can even install FREE Pilot project on you database and check how it works. We will help you with installation and give you predefined dashboards for all application areas (10 reports + dashboard per cubes) and set up 1 hour workshop to explain the functionality.

BI4Dynamics offers huge businss value out of the box and consists of:

· Data warehouse

· ETL

· Olap cubes: Sales, Purchase, Inventory, Receivables, Payables, General ledger, account schedules, sales and purchase orders analysis (open document analysis - not possible in NAV), manufacturing, service managements, jobs & resources

· We have developed two additional solutions for vertical industry: Pebblestone Fashion, LS Retail.

· Pre defined reports for Excel/SharePoint, MicroStrategy

You can check out:

BI4Dynamics online demo (SharePoint): http://www.bi4dynamics.com/en/downloads

Free trial: http://www.bi4dynamics.com/en/downloads/112-trial

Please don’t hesitate to contact me if you need any additional information. I’ll be glad to help.

You can reach me at: kl@bi4dynamics.com

Best Regards,

Klemen

3

Hi Sean,

I suggest you take a look at BI4Dynamics. BI4Dynamics is proper data warehouse solution with olap cubes. It pulls data out of NAV transfers it to separate Data warehouse, where data is transformed to proper structure (Kimball star schema), cleaned and then populated to the cubes.

You will be able to work with solution with no training at all if you know how to use pivot tables.

· BI4Dynamics covers following cubes: sales, purchase, inventory, receivables, payables, gl, account schedules, sales and purchase orders, service, manufacturing, jobs & resources.

· Vertical solution modules: LS Retail, Pebblestone Fashion.

You can check out:

· We offer free trial: http://www.bi4dynamics.com/en/downloads/112-trial (We offer free pilot projects to limit customer risk. You can test solution on your data. We offer free support to get you up and running. We will also provide you with some sample dashboards and reports for easier start and set up 1 hour free workshop to explain key features).

· On line demo: http://www.bi4dynamics.com/en/downloads

Please don’t hesitate to contact me if you need any additional information. You can reach me at: kl@bi4dynamics.com or visit web for more info: www.bi4dynamics.com

Best Regards,

Klemen