Is it possible to apply join with the Hierarchy table also?

[#1]

Hello evryone,

I am trying to apply join with hierarchy table and my fact table to apply some condition and calculation during load time,

so that i can overcome the load of using variables in my dashboard.

Please help me as it is giving me error.

Thanks in advance/

[#2]

share your file or your script for better understanding of problem so that a proper solution can be provided.

[#3]

This is my file in which iwas trying to join hierarchy table with the fact table..