Search

SSAS Tabular always uses "," as list separator in Roles by bobhen

Active

3
0
Sign in
 to vote
Type: Bug
ID: 765941
Opened: 10/3/2012 10:00:54 AM
Access Restriction: Public
0
Workaround(s)
1
User(s) can reproduce this bug
When creating formulas in Tabular in measures and calculated columns the list separator uses ";" but when creating roles it only accepts "," event though the separator is supposed to be ";"
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Analysis Services

Operating System

Windows Server 2008 R2 Datacenter

Operating System Language

English

Steps to Reproduce

Create a simple formula in a calculated column like CONCATENATE(table1[a];table1[a]) works fine.

Creating a new Role using a formula like IF(Sales[s]=100;true;false) will fail. Using "," will not fail IF(Sales[s]=100, true, false)

Actual Results

The approach using ";" when creating a role returns an error : "The syntax for ";" is incorrect.

Expected Results

No error when using ";" as separator

Platform

X64

Virtualization

Hyper-V (On-Premise)
File Attachments
0 attachments
Sign in to post a comment.
Posted by Marco Russo on 10/3/2012 at 10:30 AM
I can reproduce this behavior with Italian regional settings (using OS and SQL2012 in English)
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement