Essbase ASO Hierarchy - Essbase Studio

Hi all

Quick question on Essbase ASO Dimension Hierarchy.

I've a scenario where I need to create a hierarchy based on three data fields (suppose ColA,ColB and ColC) where ColA is parent of ColB and ColB is parent of ColC.

So, I've defined the hierarchy in Essbase Studio as below:

ColA

--ColB

----ColC

Now, there are no null values in the data for ColA and ColC in the database but there are null values in ColB.

My requirement is: whenever there are null values in ColB, the ColC value should appear directly under ColA skipping ColB. I assume this is possible. If this is possible to do in Essbase, how to achieve it? Any ideas are appreciated!