Dimension format
Posted: Fri Oct 14, 2011 6:40 pm
How do you write a formula for customized dimension format in order to make a 10 digit input number show as xxxxxx-xxxx?
Hi
What i understand from the requirement is ..You have a dimension elements are in 10digit number like 1234567890 and you want all the elements to convert as 1234567-890.
If this is the requirement then i prefer not to convert all the elements to this format.Instead create a alias attribute for the dimension and through a TI process read all the elements and convert each element to string and then convert to 1234567-890 format and use the alias in the subset when used in cube.