Number of logical dimensions for column

Question

Hello,

Here is the thing:

I noticed that when I enter Levels for some columns only some dimensions apper, in my example there is only 2 dimensions (but for others there more - why?)

I also noticed that if I set aggregation (sum ie) for this column, then all dimensions appear, not only 2.

Please help me understand how does it work? Why for some columns all logical dimensions display and for others only some of them?

2973433 · Answer

I don't think it's relevant beause this table joins actually 3 different tables.

Simon.D · Answer

The columns which aren't displaying all logical dimensions in the levels tab probably cannot be physically joined to the dimensions it's not displaying.

2973433 · Answer

Thank you for the answer,

1. How is the logical star schema relevant to logical levels for column? I cannot see any connection.

You say Notice that the for example DocumentoPagarDim is not part of the Star Schema, but still, what does that change in your example?

2. Second thing is that I have more  than 2 logical dimensions in business model. I mentioned that: there is only 2 dimensions (but for others there are more - why?)

And also let me repeat this again: When I set aggregation for the same column, suddenly all logical dimensions appear in Levels tab - why?

3. And one more question, you say:

an example of this, a company might want its revenue based on the year,  quarter, etc.  To achive this YearRevenue, QuarterRevenue, etc, this is the real utility of this.

But even if I don't set any Levels for the measure (Revenue for example) and I create an analysis with this Revenue and Time Hierarchy, I assume that also I will be able to see result based on Month or Year, right? So where is the difference?