Prev: Data Validation in another sheet
Next: How do I remove redundant rows at end of sheet?
From: 578117 on 30 Sep 2009 15:16
When point a blank Excel file at a cube, the expand/collapse buttons don't
show after adding rows and columns to the pivot. However looking at this
cube in SQL via Browse, the same rows and columns, the rows fields have the
expand/collapse buttons.
From: 578117 on 30 Sep 2009 19:02
That was Excel 2007 by the way. We have many cubes, and all cubes when
brought into Excel 2007 the rows have the Expand/Collapse buttons, except a
couple cubes. Is there a BI attribute that needs to be turned on when
building a cube that would affect the Excel Expand/Collapse buttons from
showing?

"578117" wrote:

> When point a blank Excel file at a cube, the expand/collapse buttons don't
> show after adding rows and columns to the pivot. However looking at this
> cube in SQL via Browse, the same rows and columns, the rows fields have the
> expand/collapse buttons.
From: 578117 on 1 Oct 2009 17:24
Is there an attribute for all dimension fields in a cube that needs to be
turned on for the expand/collapse to show in a pivot in Excel? We have many
cubes built by different people. All cubes (except 2) show the
expand/collapse buttons in Excel2007 for any dimension field, even fields
that have no logical hierachy when added to the pivot row produce the
expand/collapse buttons. There must be a cube dimension attribute that is
not turned on for these 2 cubes that cause it to not produce expand/collapse
buttons in Excel. Or, can someone look up in Excel what turns on those
buttons from an OLAP data source?

"578117" wrote:

> That was Excel 2007 by the way. We have many cubes, and all cubes when
> brought into Excel 2007 the rows have the Expand/Collapse buttons, except a
> couple cubes. Is there a BI attribute that needs to be turned on when
> building a cube that would affect the Excel Expand/Collapse buttons from
> showing?
>
> "578117" wrote:
>
> > When point a blank Excel file at a cube, the expand/collapse buttons don't
> > show after adding rows and columns to the pivot. However looking at this
> > cube in SQL via Browse, the same rows and columns, the rows fields have the
> > expand/collapse buttons.
 | 
Pages: 1
Prev: Data Validation in another sheet
Next: How do I remove redundant rows at end of sheet?