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!
Have you tried using Analysis Studio instead?
Quote from: bi4u2 on 25 Jun 2012 09:36:26 AM
Have you tried using Analysis Studio instead?
No - We don't have Transformer setup yet for Analysis Studio.
I have never had any luck with using dimensional data in query studio.
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?
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.
RL_Boston, were you able to solve this issue ?
I am stuck with exactly same issue !