Skip to Content
avatar image
Former Member

Lookup data in another table

Let's say I have a 2 dimensions that are numeric. To get the text value for each numeric value I have join with another table.

What do I do to get those values in the report?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 05, 2015 at 08:47 PM

    Can someone let me know if this is the right approach? I added a dimension variable with the following formula:

    =[Fname] + " " + [Name] ForEach([Sent To]) In Report

    That only works on the ones that have distinct [Sent To] values. On the ones that don't I get #MULTIVALUE

    What am I doing wrong?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      #DATASYNC means that some dimension is not merged. How many queries do you have ? Which object comes from which query. I´ll post a screen shot of what I mean by creating a detail variable.

      Try concatenating FNAME and NAME , like [full name]= [FNAME]+[NAME] and create a detail variable on [full name].

      merging dims.png (92.6 kB)