can one add a column and concatenate two fields using the olap extentions interface?

Feb 25, 2013 at 10:44 PM
can one add a column and concatenate two fields using the olap extentions interface?
Coordinator
Feb 26, 2013 at 12:20 AM
Can you describe how you want the PivotTable to look? Are the columns dimensions or measures?

You might also study the Calculations Help page for some simple examples:
http://olappivottableextend.codeplex.com/wikipage?title=Calculations%20Help&referringTitle=Home
Mar 4, 2013 at 5:12 PM
Edited Mar 5, 2013 at 3:07 PM
Hi there, Thanks for the response. The data we receive in our cubes has two numbers(actually treated as text) that uniquely identify any cost that hits a particular task on a project. I was hoping to concatenate the two into one larger number. The rows are project and task, the columns are years and months, the data is the cost for that month on a particular project/task. I think this describes the dimensions and measures respectively. I’m hoping MDX has simple concatenate capability for text fields in the dimensions ( I think). We use the pivot table as a “database” to look up certain information and display it Best Regards, Re: can one add a column and concatenate two fields using the olap extentions interface? [OlapPivotTableExtend:434475] From: furmangg Can you describe how you want the PivotTable to look? Are the columns dimensions or measures? You might also study the Calculations Help page for some simple examples: http://olappivottableextend.codeplex.com/wikipage?title=Calculations%20Help&referringTitle=Home
Coordinator
Mar 5, 2013 at 3:01 AM
You may want to edit your post to remove a little personal info, by the way.

You can concatenate strings in MDX using the + sign. You might try something like:

[Project].[Project Code].CurrentMember.Name + [Task].[Task Code].CurrentMember.Name

But for that to work, you're going to have to put Project and Task on rows, so I'm not sure that's going to provide a ton of value.

The other concern is that when you add a measure like that, it will always return a value and will cause you to show every combination of project and task, even if other measures are null. So you may want the measure read like:

IIf(
IsEmpty([Measures].[Your Other Measure])
,null
,[Project].[Project Code].CurrentMember.Name + [Task].[Task Code].CurrentMember.Name
)

If that doesn't do the trick, it's probably best to ask for further help with MDX at:
https://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/
Mar 5, 2013 at 3:08 PM
thanks for both :)