Creating a Data Set in Report Studio?

[KristieLee1]

Is it possible to create a data set in Report Studio?

Example:

Region
1
2
3
4
5
6
Region's 1-3 will be in Group 1, Region 4-6 Group 2.

I thought there was someplace I could create my own data set? Is that only in Analysis studio?

Thank you!

 

[KristieLee1]

Oh...I forgot. I want to display them grouped together, so using a prompt to show group 1 or group 2 wont work, as I need to see both groups at the same time.

Sorry for the confusion. Thank you.

 

[blom0344]

Sure , create a new dataitem [Group] like:

CASE 
WHEN
[Region] in ('1','2','3') THEN 'Group1'
WHEN
[Region] in ('4','5','6') THEN 'Group2'
ELSE 'no Group'
END

Ties Blom

 

[KristieLee1]

I was so happy when the data item validated, only to have my dreams crushed when the report threw the following error:

Invalid coercion from 'memberSet' to 'string' for '[Region]' in 'case when [Region] in ('R01D02','R01D03') then 'Group 1' when [Region] in ('R01D04','R01D05') then 'Group 2' else 'No Group' end'.

I read somewhere that I need to create a set expression? Not sure how to do that either. Is this because of a data type issue?

Thank you TB...for being a super genius!!!

 

[blom0344]

Sorry, I was expecting a relational package. You must be working with a dimensional one..

Syntax should be different then, have to test this..

Ties Blom

 

[KristieLee1]

Yes...dimensional...sucks. I'm really struggling with this. Thanks for any help you can provide