You can bring in the text about the charge. It is possible for the FACT table to also act as a dimension table. Basically you create a bnew dimension based on the fact table and then add it to the cube. The relationship type will be FACT and in the dimension make the text an attribute of the dimension.

It is possible however as with everything there is a price. Once you do this you end up with a dimension with as many members as the fact table and the users will never ever ever stop from asking you to add every single field into this new wonderfull dimension. This is assuming that the text is unique for each. I have seen some lovely cubes trashed beyond hope by doing this so proceed with caution.

E

😎