Question:
I am running a query which keeps displays certain values as 'Not assigned' or '#' whereas the in the cube tables they are empty fields. Other empty fields in the cube are shown as such in the query.
I do want 'Not assigned' or '#' to appear for any empty field in the query. How can this be done?
thanks in advance
Answer:
you should distinguish zero values (key figures) and values that are not assigned (characteristics)
what do you mean with the "Cube tables"? you should be looking into the dimensions...
cheers,
El Belgio
Answer:
For integrity the dimensions will need to have a value so if the transactional data does not contain a entry for this dimension then it enters a # - not assigned.
For example if you have a transactional record with
Customer Material Qty Value
ABC BOOK 1 10
ABC 2 5
the result will be the second line will produce a # in the material Dimension as it has no values.
So if you don't want # unassigned you will need to make sure that every record has an entry for the characteristics in the transactional load.
Answer:
If you just do not want to display '#' value in query result, modify characteristic in query, make it restricted char. In doing so, just EXCLUDE '#' value.
Hope it helps.