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!

Dynamically creating cube

Status
Not open for further replies.
tomgao

tomgao

Programmer
Feb 25, 2003
30
NG
Hi guys

I'm investigating whether if its possible to Dynamically create a cube. Then Process this cube before exporting it to a .cub file.

I know that DTS in sqlserver is able to process a cube given at a scheduled time interval. But I'm not sure how I can export a cube to a offline .cub file dynamically. The only way that i know to create a .cub file is via PivotTable in Excel.

Any help in pointing me to the right direction is appreciated.

Thankyou
Tom
 
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
179
Komal0735
Komal0735
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
158
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
291
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
194
JP_Quinn
JP_Quinn
skanskan
  • Locked
  • Question
Data Mining Cubes?
Replies
1
Views
164
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top