Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Period Dimension in excel 2000 pivot tables

Status
Not open for further replies.
surbha

surbha

MIS
Jul 22, 2004
1
US
Hey Guys,

I have a cube with a Period Dimension, in which the hierarchy is as follows:

Year
Quarter
Month
Day

Users access the data via a pivot table.

The problem is that whenever a new month comes in, the pivot table doesn't automatically display data regarding the new month. Can someone please help me here.

Thanks,

Surbha
 
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
157
Benedito Almeida
Benedito Almeida
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
160
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
293
Motlatjo
Motlatjo
Motlatjo
  • Locked
  • Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
161
Motlatjo
Motlatjo
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
197
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top