Chaining RBS values together into 1 field - Portfolio Analyzer

[TroyS]

Is there a way to create a custom field in Portfolio Analyzer that chains all
of the RBS values together into 1 field?

Rather than have to drag each RBS level into Portfolio Analyzer as a
separate field (we have 6 levels) and then have to click on each one to show
it i'm looking for a way or the syntax in a created field to chain them
together.....

I've tried [Level02]&[level03] but that did not work

thanks for any insight....

 

[John M.]

Unfortunately, the dimensions are defined as part of the OLAP build process.
This process decomposes the single character-separated value into the various
"Levels" of the dimension. The members of each level are then defined. The
only way that I can think of for recombining the fields is to extend the OLAP
cube building process. Without doing so, the best you can do is probably to
define the view with all of the levels already expanded.

John M.

 

[TroyS]

thx. I just wanted to be sure before i tell everyone this.

Unfortunately, the dimensions are defined as part of the OLAP build process.
This process decomposes the single character-separated value into the various
"Levels" of the dimension. The members of each level are then defined. The
only way that I can think of for recombining the fields is to extend the OLAP
cube building process. Without doing so, the best you can do is probably to
define the view with all of the levels already expanded.

John M.

Is there a way to create a custom field in Portfolio Analyzer that chains all
of the RBS values together into 1 field?

Rather than have to drag each RBS level into Portfolio Analyzer as a
separate field (we have 6 levels) and then have to click on each one to show
it i'm looking for a way or the syntax in a created field to chain them
together.....

I've tried [Level02]&[level03] but that did not work

thanks for any insight....