Cubes and .Net applications

What are the pros and cons of accessing the data in a cube through a visual studio 2005 .net application?Are you referring to a .NET 2.0 application (since Visual Studio 2005 is a development environment) - if so, that's rather an abstract question? Could you provide more specifics of the application usage scenarios you have in mind?|||Yes, I am referring to a .NET 2.0 application. Normally, our .NET application uses a webservice to runs sqls to retrieve data for reports in the application. I would like to know what is involved in retrieving data from the cube using a webservice. Is it more involved? Are there any benefits or risks to using a cube to retrieve data for a report in a .NET application versus just using DB2 databases? We currently retrieve our data from DB2 databases.

Cubes

Hi,
I have two Data Sources from two different servers.. Using that i have
created two cubes namely HostCube and Applications Cube..Now i need to
link the two cubes based on host name.. Host name is present in Host
cube and Site name is present in Application cube.. I need to link
these both and get the keywords, referal page, number of applications
running and number of visits.

Am not able to link two cubes and get the result.. I tried using
Virtual Cubes, but it just takes dimensions from both the cubes and
gives the result.. Can anyone help me out in this please.
Thanks in advance..

I would guess you are trying to use AS 2000 to solve the problem.

You should be way better off using AS 2005 that allows you to use data from 2 different datasources in a single cube.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward,

Thanks alot for your reply..

Yes am using AS 2000.. Now i have copied table and all the tables are in one database..

Here I have a basic question... Can we use dimensions with conditions in Analysis service.. I have three dimensions and i need output for particular condition..
For example: I have Site Dimension, Host Dimension and Tracking Details Dimensions.. Here From Host Dimension I need to take Host Name and compare it with SiteName in Site Dimension and from this i need to take site type and siteid and comapre this site id with siteid in Tracking Details Dimension and get keywords and referer excluding for status=180..

Am totally lost.. Can you help me out in this.. Thanks in advance..

|||

Looks to me the problem you are trying to solve should be solved on the client side. Try installing eval version of ProClarity and see if cross drill ( or drill across) functionality gets you you what you need.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.