Re: OLAP Cube in Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: anker (anker_at_discussions.microsoft.com)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 06:39:04 -0800

Thanks a lot... works fine.

Michael

"Michael Vardinghus" wrote:

> I couldn't find it as a feature in the olap client - so you have to code it
> like this:
>
> Sub CheckSetting()
>
> Dim pvtTable As PivotTable
>
> Set pvtTable = Active***.PivotTables(1)
> pvtTable.DisplayEmptyRow = True
>
> End Sub
>
> If you need more coding I can recommend
> microsoft.public.office.developer.web.components...
>
>
> "anker" <anker@discussions.microsoft.com> wrote in message
> news:6BC7E425-AEF9-4E65-B606-EF66BEA21610@microsoft.com...
> > Hello all,
> >
> > I've imported an SQL OLAP Cube from the Analysis Server into Excel 2003.
> It
> > is a sales cube with a product dimension in rows and a time dimension in
> > columns. The measures are the invoiced amounts.
> >
> > My problem is, that I want to display all months of the year regardless of
> > the fact whether they contain any data. For example in 2004 I want to
> display
> > the december column although no sales have been done for this month yet.
> >
> > Displaying this cube within the the analysis server this is no problem as
> > empty members are shown, but this is not the case in Excel. The december
> > column in this example is not displayed.
> > There is an option field within the PivotTable Properties Form in Excel,
> but
> > his field is disabled.
> > I've not found any point in Excel to change this behaviour and to display
> > empty columns. Can anyone help?
> >
> > Many thanks in advance.
> >
> > Michael
>
>
>

Quantcast