Should I create a column for this information

[Anonymous]

Hi there,

Just a best approach question here.  I bring in a certain set of columns from our CMDB for reporting on stock levels and such.  One of the things I need to report on is what is allocated and what is available.  Should I just add column to the original query that looks for various conditions to update a value with Allocated or Available.  For example, we have assets that are assigned to sys-admin pool that would be available, but IT Infrastructure, Shared, <the users name> and a few other options would be shown as Allocated.

I assume a column at the point of data transform would be the way to go, just not sure if that is the logical approach.

S.

[amitchandak · Accepted solution]

@Anonymous , column adds additional loading time(data loading). But if the measure calculation takes too much time for the same stuff, I usually prefer columns to reduce report time.

[Anonymous]

Thanks, columns was what I was thinking also so will look at that.  Cheers.