My question is also very similar . Can we have a dimension which act as a fact.
For example, say i am having a dimension System with hostname, ip address, device models, device type.
Hierarchy would be device models -> device type.
So, without the fact table, can i not find out how many hosts are there for a particular device models, the count of different device types under a device model ?