largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
I have an olap database which I am connecting to and I'm wondering if it is possible to pull back a list of all of the cubemembers beneath a level of hierarchy.
So for example, I have a pivot table which is connected to the database. It displays team names as rows. I can expand each team name by clicking the expand button and it displays all of the players that are on the team. They are hierarchically connected as the only field I have in the pivot table row section is "teams" (and not two separate fields as "teams" and "players"). For the values section I have "# of goals"
What I would like to be able to do is use (I think) a combination of cubeset and cuberankedmember so that I can put in a function that says to pull back the player name who has the most goals based on the team I indicate and/or other filters. I know this may not be possible, but it would be cool if it is.
So say I have the following layout:
A1 = Team Name from pivot table
A2 = Year
I want to do something in A3 that is like cuberankedmember(cubeset,1), where cubeset = something like cubeset(A1,A2, sorted descending, based on goals).
Basically having the cubeset be the set of players who are under the hierarchy of the team in A1, filtered for the year I specify in A2, sorted by # of goals descending.
Sorry I know this is confusing, but if anyone has any insight or links to info where I could figure this out I'd greatly appreciate it.
Thanks!
So for example, I have a pivot table which is connected to the database. It displays team names as rows. I can expand each team name by clicking the expand button and it displays all of the players that are on the team. They are hierarchically connected as the only field I have in the pivot table row section is "teams" (and not two separate fields as "teams" and "players"). For the values section I have "# of goals"
What I would like to be able to do is use (I think) a combination of cubeset and cuberankedmember so that I can put in a function that says to pull back the player name who has the most goals based on the team I indicate and/or other filters. I know this may not be possible, but it would be cool if it is.
So say I have the following layout:
A1 = Team Name from pivot table
A2 = Year
I want to do something in A3 that is like cuberankedmember(cubeset,1), where cubeset = something like cubeset(A1,A2, sorted descending, based on goals).
Basically having the cubeset be the set of players who are under the hierarchy of the team in A1, filtered for the year I specify in A2, sorted by # of goals descending.
Sorry I know this is confusing, but if anyone has any insight or links to info where I could figure this out I'd greatly appreciate it.
Thanks!
