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 ?