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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AS 2000: Virtual Cube Calculated Measures

Status
Not open for further replies.
rackman99

rackman99

Programmer
Sep 16, 2002
29
0
0
GB
Hi,
I'm just starting off in the AS path and was hoping someone can help with a speed poser. I have 2 cubes (one normal measures the other a Distinct Count) which both have calculated measures (OpeningPeriod for a time dim)
These 2 cubes are then combined into a Virtual cube, on which I have also imported all the calc measures. My question is, do I now need the calc measures in the normal cubes? Will duplicating the measures cause the query of the cube to slow down (via Excel 2003 Pivot/Getdata)

Cheers
 
Status
Not open for further replies.

Similar threads

Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
68
Komal0735
Komal0735
Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
60
Benedito Almeida
Benedito Almeida
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
56
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
121
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
79
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top