Hi There,

I'm probably going to use all the wrong terms, so please bear with me.

I have a cube dimension that has many attributes. Some are useful for
sliceing up the data in my fact table.

But some are just interesting text/information that I'd like to appear next
to the useful ones above.

The problem I'm having is that everytime I put a "just interesting" one onto
my pivot table, I get a plus sign and a total line. This isn't applicable
as the information is specific to that one row.

Is there any way to turn off this type of grouping on these attributes so
that this doesn't happen?

Any suggestions would be GREATLY appreciated.

Thanks.

in the pivottable you can right click on a member and display properties in
the report.
for example, you have a customer dimension and for the customer name level
you have the gender attribute, which is a property of the customer name.
in the pivottable, right click the customer name and you have an option like
"display properties" and the list of the properties available and you'll
found the gender. Check the one you need and the content is displayed
without the grouping.

"K. Bryan" <notme (AT) kbryan (DOT) net> wrote

Thanks for the response, but don't those appear "differently"?

I am trying to get them to appear as normal columns in the table. and also
as there are many of them, if possible, to have a user just be able to drag
the ones they want without the grouping/total thing happening.


"Jeje" <willgart (AT) hotmail (DOT) com> wrote

you can't "lock" the expand/collapse and force it to expand by default.

but you can "expand all" in 1 click, push the 2 attributes like you do now,
do a right click on the column header of the first attribute on his header
and you have an "expand all" option.

"Kevin B. Campisi" <kevin (AT) campisi (DOT) org> wrote