I want to create a dimension where I can assign a speciffic value.

[gwmills_fiserv]

I have a data model with value for different types of collateral.   I would like to divide the total by a specific number, but there is no field for that value.   I want to create a dimension that would hold the specific value so I an reuse it in calculations.  For example, I want to assign the value $750,000,000 to the dimension named Capital.

If I could make it driven by a variable that could easily  be changed, that would be a bonus.

[Anil_Babu_Samineni]

Question not clear to me. Can you rephrase for me

[PeterVanOers]

If I understand you correctly a variable is the solution.

Somewhere in the load script:

Set vCapital=750000000;

In a calculation:

=Sum(FieldToSum)/$(vCapital)

In the november version with de Dashboard Bundle there's an extension called variable input which you can use to modify your variable.

Regards Peter.

[gwmills_fiserv]

Thank you!   That worked.