Olap Cube

[alesencevennes]

Hi, does anyone knows to handle an OLAP cube?
I have an OLAP cube that I'd created in Excel, this is into an Excel file. This file has got many sheets and on every sheet I've put as PageItem the same field "DateTime".
Every time I am trying to select a certain date I must do the same for every sheet. But I want to do this only once, meaning I want to select only one time the date on one sheet, and automaticaly the others sheets to have the same date selected. Not to be obligated to go to each sheet and to do the same work every time.
Once I have selected the date in the others fields of the sheet (Row, Column and Date Items) there will be selected and shown the datas that I need to visualize in the table. These datas are extracted from an SQL database (SQL Server).
Thanks!

 

[SkipVought]

Hi,

Turn on your macro recorder and record changing one. Then modify the code to loop thru the sheets and change each one.

Skip,

_[red][/red]

 

[alesencevennes]

Hi,
Well, I'll try this. If I cannot manage perhaps I will ask you to help me with some code lines.
Until now I used a code that does a PivotTable update.
The code that I'm using is the following:

Sub AllWorkbookPivots()
Dim pt As PivotTable
Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

For Each pt In ws.PivotTables
pt.RefreshTable
Next pt

Next ws

End Sub


I was thinking is a good one, but doesn't do much, just keeps my Excel file busy updating the PivotTable-s.


Thanks

 

[SkipVought]

"...but doesn't do much, just keeps my Excel file busy updating the PivotTable-s"

Is that not what a program does, instead of YOU, wasting time updating the PTs yourself.

What's the point here?

Skip,

_[red][/red]