Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 270 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
Options
Default Cube fixing
PapaSmurf
Member Posts: 4
Apologies in advance - I am neither an AX or SQL Analyses expert. We have yet to go live with AX2009 but we're having trouble with installation - in particular with reference to configuring the default OLAP cubes due to configuration keys etc.
I'm using the Default Cube advisor Tool, which has successfully guided me through amending a couple of named queries.
Next in the list is the following; (this is the first cube, Accounts payable)
Here's where I'm stuck. I don't see "Company information" in the Cube dimension list, but it does seem to exist in the shared cube list. The inverse is true of the "Vendor Master" which does exist in the cube list but not the shared list.
Can anyone shed any light here, or have any other methods for fixing these cubes with more automation?
Thanks
I'm using the Default Cube advisor Tool, which has successfully guided me through amending a couple of named queries.
Next in the list is the following; (this is the first cube, Accounts payable)
1.2 Following Dimensions and/or Dimension attributes are referenced by the cube. They need to be fixed or removed since dimension members’ source data from tables that are no longer valid given disabled configuration keys (The dimension name listed below is the cube dimension. You need to fix the shared dimension referenced by the cube.)
Dimension Attribute Recommended action
Company information Reporting Currency ID Remove attribute
Company information Triangulation currency Remove attribute
Vendor Master Femaled Owned Remove attribute
Vendor Master Minority Owner Remove attribute
Here's where I'm stuck. I don't see "Company information" in the Cube dimension list, but it does seem to exist in the shared cube list. The inverse is true of the "Vendor Master" which does exist in the cube list but not the shared list.
Can anyone shed any light here, or have any other methods for fixing these cubes with more automation?
Thanks
0