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
-
-
Why Do Power BI Copilot AI Instructions Seem To Work Better in Desktop Than In The Service? - I’m spending a lot of time with organisations testing Power BI Copilot at the moment, and something I hear a lot is that Copilot works well in Desktop but ...21 hours ago
-
-
DAX Studio v3.3.0 Released - I’ve just released v3.3 of DAX Studio. The list of updates and fixes is available here v3.3.0 Release | DAX Studio1 month ago
-
My MontrĂ©al is at the intersection of Poutine, Politics, and Pancakes - A couple of lifetimes ago, I was a student living in MontrĂ©al — back when I thought I could survive off of baguettes, shawarma, and bagels. I went to McG...2 weeks 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...17 years ago
-
-
New composite models in Power BI: A milestone in Business Intelligence - Power BI sets a new milestone in Business Intelligence: Marco describes the importance of new composite models in an article, and Alberto shows them in act...4 years 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...15 years ago
-
SQLCAT at PASS Summit 2018 - This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years...6 years ago
-
-
DAX Code Snippet: Year To Date in Charts - This short blog post tries to show the different ways to solve the same problem in DAX and in MDX. If you look at the picture you can see two ways of prese...10 years ago
-
No comments:
Post a Comment