11.7 Model View Properties
Select a field in Model view to see its Properties pane:
- Name, Description (shows as a tooltip in the Data pane)
- Display folder – group measures into folders (e.g.
Sales KPIs,Delivery KPIs,Time Intelligence) - Is hidden – hide key columns and technical fields from report authors
- Data category – e.g. City, State or Province, Country, Web URL, Image URL (helps maps and tables). For DarkStore, set City = City, State = State or Province, Country = Country.
- Summarize by – default aggregation (set None for IDs and years so they are not summed)
- Format – currency, percentage, thousands separator, decimal places
Measure tables, display folders and formatting
Module 8.13 shows step by step how to create a _Measures table, organise measures into display folders and format them in ₹.
Ravindra Bagale's Tip
A common mistake is leaving foreign keys (Orders[Store ID], Orders[Product ID]) visible, so report builders drag them into visuals instead of the dimension columns. Hide keys in the fact table, and set data categories (City, Postal code) and default summarisation in Model view. It's very simple – just make it a habit.
Ravindra Bagale's Tip – मराठी
एक common चूक म्हणजे foreign keys (Orders[Store ID], Orders[Product ID]) दिसू देणं, त्यामुळे report बनवणारे dimension columns ऐवजी त्या keys visuals मध्ये ओढतात. Fact table मधल्या keys hide करा, आणि Model view मध्ये data categories (City, Postal code) आणि default summarisation set करा. एकदम simple आहे, फक्त सवय लावून घ्या.
Ravindra Bagale's Tip – हिंदी
एक common गलती है foreign keys (Orders[Store ID], Orders[Product ID]) को दिखता छोड़ देना, जिससे report बनाने वाले dimension columns की जगह उन्हें visuals में खींच लेते हैं. Fact table की keys hide करो, और Model view में data categories (City, Postal code) और default summarisation set करो. बहुत आसान है, बस आदत बना लो.