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!

AS 2000: Virtual Cube Calculated Measures

Status
Not open for further replies.
rackman99

rackman99

Programmer
Sep 16, 2002
29
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
175
Komal0735
Komal0735
Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
151
Benedito Almeida
Benedito Almeida
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
154
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
287
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
186
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top