Custom Values for user dimensions

• 

  Louise Stub Hansen

  September 10, 2021 10:14

  Hi Bo

  Im not sure if I understand your question correct?

  When I create a user dimension, Im able to select criterias from all dimensions.

  Maybe you can show a screendump of your problem?

  

  0
• 

  Bo Jacobsen

  September 10, 2021 10:50 (Edited September 10, 2021 10:51)

  HI
  
  The problem is that i can make use of custom values for user dimensions in some cases
  

  but not others
  
  

   

  and i was wondering if it had something to do with Data Format or Data Type in the datawarehouse.

  0
• 

  Louise Stub Hansen

  September 10, 2021 11:05

  Hi Bo

  Now I understand your question :-) Unfortunately I dont have a good answer.

  It seems like it has something to do with dynamic time? I dont get the options at time dimensions with dynamic time. But all other dimensions it seems like Im able to choose custom values.

  Hopefully someone else have an explanation.

  0
• 

  Ole Dyring

  September 10, 2021 11:09

  Hi Bo,

  Yes, it is most likely because TARGIT will only treat string data types as something that can be set up with 'Custom values'.

  So you might need to change the data type in the data warehouse. If this field is also used as a measure, then you should create a copy first (you will want to keep the measure as a numeric data type).

  BR / Ole

  0
• 

  Bo Jacobsen

  September 10, 2021 11:18

  Hi,
  
  I changed the Data Type and Data Format to Text and I can now use custom values.
  
  Thanks for the help.

  0

Please sign in to leave a comment.