on 01-02-2015 6:43 PM
Hi BPC Community,
Re: OLS BPC 7.5 Microsoft
In a typical EVDRE report, in Excel, is there a way to display only the member names in the rows? Currently it’s displaying the member descriptions.
Thank you! Barry
PARAMETER | EXPANSION 1 | EXPANSION 2 | EXPANSION 3 | EXPANSION 4 |
ExpandIn | COL | ROW | ROW | ROW |
Dimension | TIME | ENTITY | DEPT | ACCOUNT |
MemberSet | SELF,DEP | BAS | BAS | SELF,DEP |
BeforeRange | ||||
AfterRange | ||||
Suppress | ||||
Insert |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sushant,
Yes. I have selected View Member By = ID Only. As you can see in the below report, the member descriptions are displayed. What I'd like to see are the member names.
Thanks for the reply. Barry
EXPANSION 2 | EXPANSION 3 | EXPANSION 4 | ||||||
ROW | ROW | ROW | ||||||
ACCOUNT | ENTITY | DEPT | RVENU | EVCON | TotalDepart | Net Revenue | Consolidated EXX | |
SELF,DEP | SELF,DEP | SELF,DEP | RVENU | EVCON | NODEPART | Net Revenue | Consolidated EXX | |
RVENU | EVCON | DEPARTWOEST | Net Revenue | Consolidated EXX | ||||
RVENU | EVCON | 100 | Net Revenue | Consolidated EXX | ||||
RVENU | EVCON | 777 | Net Revenue | Consolidated EXX |
Hi Barry,
Sorry for late reply.
Excel in 7.5 is quite flexible you can delete or insert column very easily just you need to change the ranges in the EVDRE parameters, You want to show only Id's in report then you can simply hide the descriptions from your report using simple excel logic.
OR
you can change the range and delete the column that contains the description of members as suggested by "Roberto".
Regards,
Sushant.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.