Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 297 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Business Analytics - Consalidate companies
bamver
Member Posts: 30
Hello,
I have a NV database with two different companies. I want to analyze the data of the two companies consolidated with Bussiness Analytics.
If I define a dimension which is a normal field of the fact table, the consolidation goes fine and the total of each dimension value acumulates the values of both companies. But if I choose any of the Dimensions predefined in Navision, the dimension values are replicated and the values aren't acumulated.
I read in a previuos post in this forum that this is because this type of Dimensions are built with Company and Dimension Code as primary key to aboid problems with dimensions named the same in different companies, but meaning different things. In my case, I want to have the same dimension values all over the database to be able to analize data of all companies together.
Has anyone solve this problem anyway?? Please, any idea will be welcome. I need to solve this problem urgently.
Thanks in advance,
Bamver.
I have a NV database with two different companies. I want to analyze the data of the two companies consolidated with Bussiness Analytics.
If I define a dimension which is a normal field of the fact table, the consolidation goes fine and the total of each dimension value acumulates the values of both companies. But if I choose any of the Dimensions predefined in Navision, the dimension values are replicated and the values aren't acumulated.
I read in a previuos post in this forum that this is because this type of Dimensions are built with Company and Dimension Code as primary key to aboid problems with dimensions named the same in different companies, but meaning different things. In my case, I want to have the same dimension values all over the database to be able to analize data of all companies together.
Has anyone solve this problem anyway?? Please, any idea will be welcome. I need to solve this problem urgently.
Thanks in advance,
Bamver.
0