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
-
-
Sending Alerts From Fabric Workspace Monitoring Using KQL Querysets And Activator - I’ve always been a big fan of using Log Analytics to analyse Power BI engine activity (I’ve blogged about it many times) and so, naturally, I was very happ...6 days ago
-
-
Power BI – creating dynamic per recipient subscriptions for paginated reports with multi-value parameters - At the time of writing this post there is no built-in support for creating dynamic per recipient subscriptions for paginated reports if your report has any...1 month ago
-
How Apache Spark™ performs a fast count using the parquet metadata - A common question I run into is how does Apache Spark™ perform fast counts against Parquet files. TL;DR: Spark is able to read the parquet metadata witho...10 months 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...14 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...9 years ago
-
No comments:
Post a Comment