Dimension won't display data in Query Studio filter

[RL_Boston]

Hi everyone -

I have a simple dimension table and the data within the column will not display in a Query Studio Filter.

[DIMENSION_Table]
   [KEY] [int] IDENTITY(1,1) NOT NULL,
   [NAME1] [varchar](100) NOT NULL,
   [NAME2] [varchar](100) NULL,
   [NAME2_KEY] [int] NULL,
   [NAME2_ID] [int] NULL

My problem is with [Name1], none of the data appears when I try to filter it in Query Studio. I get this error 'Syntax error - filterDialog.js'
This column is set as an Attribute, is Nullable =  false, Regular Aggregate = Unsupported.
I also have Determinant on [Key] set to Uniquely Identified.

Any help would be appreciated, thank you in advance!

[bi4u2]

Have you tried using Analysis Studio instead?

[RL_Boston]

Have you tried using Analysis Studio instead?

No - We don't have Transformer setup yet for Analysis Studio.

[bi4u2]

I have never had any luck with using dimensional data in query studio.

[bdbits]

To the best of my knowledge, Query Studio will only work with relational packages, and Analysis Studio with DMR or cubes. But you don't need Transformer to use AS, just a package with a dimensional model.

Do you have any problems querying the same table in Report Studio? At what point does the error message appear?

[RL_Boston]

In query studio, I drag the data item over.  I select the top of the column and click the filter icon.  For all my other data items, it'll automatically generate a list of whatever data is in that data item for me to select.  But for this data item, nothing appears.

I notice the error message because on the bottom right corner of my Internet Explorer window, has a caution icon and I double clicked it to get the error message.

[shahatwork]

RL_Boston, were you able to solve this issue ?

I am stuck with exactly same issue !