Hi all!
We would like to create an Intranet based cube administration tool.
Power users should be able to process cubes and dimensions. This works
and all the cubes, dimensions and even databases from the SSAS can be
displayed in the web! ASP.NET@.C# combined with
Microsoft.AnalysisServices offer a lot of very good possibilities!
But we still have a problem:
How ist it possible to show some kind of progress bar (maybe in a self refreshing iframe or a new window?)?
When a cube/dimension is processed the user does not get ANY feedback
(of course the webserver waits to finish the process() method.
I tried to start a different thread an this even works!
I want to show our powerusers at least some kind of progress (%, events, what ever).
can someone help? we are totally lost with that topic!
I already had a look at the example from:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=75148&SiteID=1
But it did not lead me to a propper solution :)
TIA and regards
JohnnyR
Hi Johnny,
i have tried to configure the display of my dimensions and cube on the Web but I have totally failed, could you please outline for me the proper steps of how togo about this.
You can reach me on REjalu@.cit.mak.ac.ug. or within the forums
Thanx in advance.
Ronald
|||
Hi,
maybe you should have an eye on http://www.lennybacon.com/Default.aspx#a0eaaccb3-4c0c-405f-9bde-ced4b95a1222?
cheers,
Markus
|||Hi Ronald!
This is how I manage it:
string olapserver = @."SERVER\DATABASE";
private bool getDBs()
{
Server olapsrv = new Server();
this.DropDownDatabase.Items.Clear();
try
{
olapsrv.Connect(olapserver);
foreach (Database mydb in olapsrv.Databases)
{
ListItem myitem = new ListItem();
myitem.Text = mydb.ToString();
myitem.Value = mydb.ToString();
this.DropDownDatabase.Items.Add(myitem);
}
olapsrv.Disconnect();
return true;
}
catch
{
olapsrv.Disconnect();
return false;
}
}
private bool getCubes(string server)
{
Server olapsrv = new Server();
this.ListBoxCubes.Items.Clear();
try
{
olapsrv.Connect(olapserver);
foreach (Cube mycube in olapsrv.Databases[server].Cubes)
{
ListItem myitem = new ListItem();
myitem.Text = mycube.ToString();
myitem.Value = mycube.ToString();
this.ListBoxCubes.Items.Add(myitem);
}
olapsrv.Disconnect();
return true;
}
catch
{
olapsrv.Disconnect();
return false;
}
}
private bool getDimensions(string server)
{
Server olapsrv = new Server();
this.ListBoxDimensions.Items.Clear();
try
{
olapsrv.Connect(olapserver);
foreach (Dimension mydimension in olapsrv.Databases[server].Dimensions)
{
ListItem myitem = new ListItem();
myitem.Text = mydimension.ToString();
myitem.Value = mydimension.ToString();
this.ListBoxDimensions.Items.Add(myitem);
}
olapsrv.Disconnect();
return true;
}
catch
{
olapsrv.Disconnect();
return false;
}
}
.
.
.
<asp:DropDownList ID="DropDownDatabase" runat="server" AutoPostBack="true" />
<asp:ListBox ID="ListBoxCubes" runat="server" SelectionMode="Multiple" />
<asp:ListBox ID="ListBoxDimensions" runat="server" SelectionMode="Multiple" />
good luck!
I finally managed to get the admin page working:
My solution was the following:
I created a Windows Command Line Application that processes either
cubes or dimensions. The Application get an XMLA File Path as a command
line argument.
The XMLA file is created by my Administrator Web Page, which also launches the Command Line Tool!
The Command Line tool traces the server output and writes it into a log file!
The log file is display in an iframe (reload every 5seconds).
It works great and really fast using XMLA.
maybe somebody want to do the same!
regards
JohnnyR|||
Johnny,
if you are going to share this app with the community somewhere I would be glad if you notify me and send me a download link...
cheers;
Markus
|||Hi Markus!
Give me some time to clean up the code an to design the whole stuff a bit more understandable :)
But i will definitely post it in here or post a downloadable link!
We concidered to write a dynamic MDX query generator for the web (like
you know from the pivot table drag and drop plug in @. Excel), too! So
give me some time to design the prog a bit better ;)
regards from Vienna
JohnnyR|||
from Vienna?
Then we could do it in german also...
:-)
Glad to hear that you think of posting it!
Have you thought of getting in touch with some other projects regarding SSAS and web-"things"?
PASS Germany is currently doing a project in the SIG BI which will be a AJAX Client for SSAS.
If you would like to get in contact please just send me a mail to m.fischer [at] sqlpass.de
cheers,
Markus
