Single quotes in Admin console

[oscarforeman]

Trying to understand what the single quotes mean when you modifying a dimension in the Admin console.  We have an automation process that processes our dimensions but it does not put the single quotes back into the dimension file after completion.  Are these quotes needed? if not needed why does manually processing a dimension put single quotes into the file?

Regards,

Oscar

[Former Member · Accepted solution]

Not quite sure this is the technical answer but it is what I have observed. Since the Administrator manual edit is primarily Excel, many of the functionalities are based on Excel including the member modification. In Excel, the single quote indicates text. It isn't necessary because the processing of the dimension adds the single quote before pushing the members to the mbr & dim tables so it understands the member characters are text.

[oscarforeman · Accepted solution]

So if I am understanding correctly, even though I don't see the single quotes after my automation process runs, the system understands that it is text so everything should be fine?

Oscar

[Former Member · Accepted solution]

Hi Foreman,

normally it's fine but you can have issues if you have numeric ID or ambiguos strings like 100E1000, without single quote bpc does not understand this is an alphanumeric ID but a value with scientific notation.

Regards

     Roberto

[Former Member · Accepted solution]

Yes

[oscarforeman · Accepted solution]

So is there any process that I can run to process my dimensions like the manual processing of dimensions?  Admin make dim just copies the mbr table to the membersheet. Admin process just processes models.  Is there any other ouyt of the box dimension process?

All answers have been helpful...Just trying to make sure I have all bases covered before we move forward.

[Former Member · Accepted solution]

Hi Foreman,

no there aren't other standard packages, the only possibility is to manually change the xls file of the dimension susbstituting with new version and process the dim manually.

Regards

     Roberto