March 31, 2006 at 2:27 am
can any one tell me how to creatre the dynamic cubes from my web froms in MS sql server 2005 . so i can select the dimensions and create the cubes according to that for calulating median on different variables.
April 5, 2006 at 7:10 am
As I am new to Analysis Services and am converting existing Crystal Holos Cubes to SqlServer, I would like to do the same thing... So far the only hints I have are in the samples I downloaded.... there was this C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AMOAdventureWorks\CS\AmoAdventureWorks. Program.cs is a C program, that builds a cube.... I suspect I will try and see if I can rewrite this using VB.net and then set parameters and stuff with .aspx . Maybe it will work maybe it won't.....
June 26, 2006 at 8:17 am
I'm looking at trying to accomplish the same thing. If there is anyone that has a more in depth amount of expertise in this area, please post a comment. Your insight would be greatfully accepted.
Michael Lee
June 28, 2006 at 7:39 am
Hi all,
Are you truly trying to create new cubes on the fly or are you more interested in writing queries against existing cubes but with strict filters against the dimensions? With AS2K5 and te UDM you should be able to create a model with many dimensional attributes (with or without heirarchies) that you could query sort of like a relational system (one of the 'selling' points of the UDM).
If you're looking to create the on-the-fly cubes, what is their lifespan to be? How do you determine the aggregation mode for the measures? Do/will the 'fact' tables already exist to feed the measure groups and if not will your system be able to identify and manage a request for a multi-grained cube? There's no real reason I can see as to why you couldn't (or shouldn't) create them but I'd be interested in why your requirement is cubes over straight SQL queries if these are for once off result sets?
Steve.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply