Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-27 : 08:04:59
|
| Stoney writes "This is not exactly a SqlServer question, but it is so close that is really falls in the 'and' section of the venn diagram.I have a Category dimension on my cube (MS SQL Server 2000) with 770 members. But I want to use only 20 of them as columns in my pivot table in Excel 2003.This might work if I could just list the categories I want to have visible as columns. But instead it seems that I have to use the TreeviewControl and list the ones that should be hidden. In my case, that means listing 750 items. Is there a way? I'm running into 'too many line-continuation characters' errors and arrays that are too big.It would be nice if there were a way to loop through the items in the column-cubefield, and set to hidden all but my selected 20. But I don't know how to get down that far in the pivot table.Is there perhaps a way to modify the mdx query that passes between the cube and the pivot table? Might that work? I have no idea if or where that is, though.Thanks, Stoney" |
|
|
|
|
|
excel - olap - pivot table - too many columns