Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
BA Sales Line cube
xrivo
Member Posts: 56
Hi,
It's possible to create a cube with Sales Line like fact table, related with Sales Header (from Document No.)?
I've tryed to do such a cube but configuration doesn't work.
Thx.
It's possible to create a cube with Sales Line like fact table, related with Sales Header (from Document No.)?
I've tryed to do such a cube but configuration doesn't work.
Thx.
0
Comments
Can you explain more what you meant by this? When you say cube, do you mean a matrix box?
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
However... if it's not too late, I'd advise against BA. We spent weeks trying to configure it and finally gave up. It's too fragile. F.e. whenever we have a dimension value that has no entries associated as yet - like a new Item that has no transactions yet - it crashed.
BA is just a frontend for configuring MS SQL Analysis Services. It's only useful if you have a native database as it sets up DTS packages for exporting the data to and SQL database. If your Navision is already running on SQL server, then you only need to generate a Date table in SQL to use with Date dimensions and basically everything else is a Next/Next/OK setup with star or sometimes snowflake dimensions and setting relations in Analysis Services and it just works. It has no flowfields of course, but that's not a big problem, you just need to always uses the lowest level fact tables (Detailed Customer Ledger Entry and so on).