If you are creating cube partitions manually and if fact table is not listed, check the structure of the missing fact table with the fact table of default partition. Case might be that the structures might be different such as different or missing columns, data types of columns mismatching etc. The structure of the partition fact table should be same as default partition fact table.
Subscribe to:
Post Comments (Atom)
My Articles
Design
Fact table design for “State Workflow Analysis”: Analysis Services Dimensional modeling
Aggregation design: useful tips
Trouble / Troubleshooting
Analysis Services 2005 migration tool: Custom member formula issues in migrated database
MDX
NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
Selecting dimension's default member based on a member property
Sorting members on member codes / member properties
Time Dimension: How to set Default Member to Current Month
Setting dynamic default member in dimension X based on the current member of dimensions Y
ADOMD.NET
Code : utility code for converting cellset to a data table
Others
Google specialized search for Analysis Services and MDX web resources integrated in my blog
Blogroll
-
-
SQLBits 7 Summary - So another SQLBits is over… One of my jobs this time was to write the emails that got sent out every week and in them I used plenty of marketing phrases ...1 year ago
-
New Blog Location - I have relocated my blog. Here is the new address: http://christianwade.wordpress.com/2 months ago
-
BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) - The beta for BIDS Helper 1.6 was just released. We have not updated the version notification just yet as we would like to get some feedback on people's e...2 months ago
-
New Location - After pondering for awhile, I had decided to create a new blog using WordPress and have shifted the blogs to my new site. Come check it out at: http://den...2 years ago
-
Automating Partition Creation - By Bryan C. Smith The use of multiple partitions per measure group is promoted to improve both query and processing performance as well as the overal...4 years ago
-
-
Optimize Many-to-Many with SUMMARIZE and Other Techniques - We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that h...15 hours ago
-
Good Bye BI - "Every new beginning comes from some other beginning's end" ( Seneca ) I spent big chunk of my professional career working on what we call today BI. From P...2 years ago
-
Announcing SSAS Maestros v1.2 - We are proud to announce that SQLCAT will continue with the SSAS Maestros course in June and July in Redmond and Madrid. SSAS Maestros 1.2 Courses J...1 year ago
-
Please re-subscribe to The BI Verdict news feed - *Please re-subscribe to The BI Verdict news feed* As you may know by now, The OLAP Report is now The BI Verdict. This will be the final post on this feed....2 years ago
-
Community Connection 2010 SQL Server & Dotnet - I will be speaking at this event on the 10th of September in Malmo around about an introduction to PowerPivot for developers. It is a whole day event i the...1 year ago
-
Sharing Your Cube With Anybody (Or Everybody) - What if you had some cube data that you wanted to share with someone not connected to your network, but you wanted them to be able to browse the data as ...3 years ago

0 comments:
Post a Comment