Grouping by a members property not possible?

[florian]

Hi,

is it really not possible to group by a members property in a crosstab???

For example a fact table with sales. A dimension table with salespersons with gender as attribute. Now in a report I want to show sales by gender in a crosstab. Doesn't seem to work...
Do I really have to add the gender information into the fact table?

Thansk in advance,
Florian

[krishdw85]

Pl be clear.... if you create any expression either filter or query calculation automatically it ll be in query.
If you want to refer other query in current query..you can use it , but in query make it as Cross product allowed.

[florian]

I think we talk about two completely different things.

For my little example i want to build a report with sales data.
But I don't want one row for each salesperson, I want two rows, one for male, one for female, with the respective facts summed up.
The gender of the salesperson is a member property of the salesperson member.

[MFGF]

I think we talk about two completely different things.

For my little example i want to build a report with sales data.
But I don't want one row for each salesperson, I want two rows, one for male, one for female, with the respective facts summed up.
The gender of the salesperson is a member property of the salesperson member.

Is this a dimensional or a relational package? As you refer to Member I'm assuming dimensional? If so, you'd need to have Gender as a level in the hierarchy above Salesperson to get what you need (so you have Gender members for Make and Female). If it's a relational package, you simply need to bring in the Gender query item into the rows area.

MF.

[florian]

That's a good idea, Thanks!

[RickHenderson]

I'm working on a similar problem, but I want Gender to be the Columns not the rows. Do I need to create extra query items of something? I think that as a crosstab I shouldn't have to count the genders separately if I'm not mistaken.