How to declare 0 as an object in universe design tool 4.1

[Former Member]

I have a Sql code containing 0 declared as objects like, 0 as Networth, 0 as CustomerId . My question is how to create them as objects in universe design.

Thanks,

Yaswanth.

[former_member198519 · Accepted solution]

If you only need to create an object with 0 as a value, Just type in 0 in the select pane (Datatype as Number). Don't try to parse it as it would fail. When you will use it in the report it will appear as 0 in the report.

[Former Member · Accepted solution]

will it hold good if for example 'NA' As CustomerID, and selecting datatype as character

[former_member198519 · Accepted solution]

Yes, you can. What exactly is your requirement? What you need to achieve?

[amitrathi239 · Accepted solution]

You can go with both 0 as number data type and 'NA' as string in universe objects.