HomeSQLServerPedia SyndicationFactless fact table

Comments

Factless fact table — 6 Comments

  1. Hi,

    Can you please give with an example model where it has fact,factless fact and dimesion. And the also the relationship between the three. As per i understood was, Between Dimesion and fact it has Many to Many relationship. Same way to resolve the Many to Many relationship between Fact and dimension we use Factlessfact.

  2. Pingback:Preparation for the 70-467 SQL BI exam | x86x64

  3. I’m having trouble using factless fact tables (FFTs) in Power BI. Because I am using values from two dimensions related via a FFT, but I am not actually using any values in the FFT per se. Power BI does not appear to be enforcing any relationship between dimensions unless the visualization includes some value from the fact table in between them. Under some circumstances I could perhaps use a “counter” value from the FFT, but in this case I need to do _distinct_ counts on the operational DB key values from one of the dimensions. I have considered using the “merge query” tool to bring the data from both dimensions into one query result, but the numbers of columns and rows are so large that the process didn’t even finish before I abandoned it as a viable option. Do you have any suggestions?

    • I never got a reply to my question above, but I did resolve the issue. To address what appeared to be a quirky behavior in Power BI, I ended up putting the operational database’s primary entity key inside every fact table, including the factless fact tables. That facilitated distinct counts and allowed me to choose a value from the factless fact table itself, addressing the problem I was having. Power BI may have changed the way it works, rendering this technique moot. But it is now a standard approach for me to include the operational primary key for the entity being referenced in the row of any fact table. It has come in handy in other situations also.

  4. Pingback:Creating a Usable and Accessible Power BI Dashboard

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>