Urgent - Creating Snowflake schema using DSO
Tue, 26 Apr 2005 16:55:05 +0530
Hi,
I have been trying to automate creation of snowflake schema using DSO.
Everything seems to work fine except that the tables that make the dimension
do not show the joins.
I am adding the joins & levels (including the All level).
Any help is appreciated. Some sample code much better.
Thanks,
Pu ...
|
Problem with GetSchemaDataSet(AdomdSchemaGuid.Catalogs, Nothing) in ADOMD.nET Sample Application
Mon, 25 Apr 2005 13:06:11 -0400
I tried compiling the application provided by microsoft for XMLA/ADOMD.NET
and I cannot seem to get the code block to work. I have a valid connection
and when I debug the application using the local watch I see a datatable
that corresponds to the Catalog Schema. but when I assign the dataset table
to a local d ...
|
How to display the result set of XMLA in OWC PivotTable
Sun, 24 Apr 2005 19:01:01 -0700
Hi,
How can I consume in my PivotTable the xml (see file attached) returned
by xmla.
I can't find any sample that presents the xmla results in a pivottable.. I
read somewhere that I need to transform the xml thru an xmlt transformation
but I don't know the xml format for the PivotTable..Please help.. ...
|
ADOMDConnection.Open fails on Win2K3 Server
Fri, 22 Apr 2005 16:39:43 -0400
Background:
Development configuration: Win 2KPro; VS.Net. Downloaded ADOMD.Net
installation and Analysis Services HotFix. Installed, switched code from
ADOMD to .Net and everything works. Used the same connection string in
both cases.
Do the same thing on Server 2003 machine:
First Error: "No connect ...
|
AdomdConnection.Open() failed
Thu, 21 Apr 2005 13:57:03 -0700
Hi:
I' ve got a problem with ADOMD.NET 8.0 Release and XMLA 1.1 Release when
attempt to open a connection. The exception is recieved executing the
discover DISCOVER_SCHEMA_ROWSETS, after execute the discover
DISCOVER_DATASOURCES correctly
The code I'm using is
AdomdConnection connection = new Ado ...
|
Parches de microsoft
Thu, 21 Apr 2005 15:37:17 +0200
Me han mandado un parche por correo para mi windows pero no se si abrirlo, tengo miedo ^^ ...
|
Drillthrough MDX Problem ..
19 Apr 2005 08:48:26 -0700
Hi All,
I am running a simple DrillThrough MDX on FoodMart 2000 on Sales cube,
the MDX is :
DRILLTHROUGH MAXROWS 1000
SELECT {[Customers].[All Customers].[USA].[CA].[Berkeley]} ON 0,
{[Time].[1997]} ON 1,
{[Product].[All Products].[Drink]} ON 2
FROM Sales
But it shows the following error:
...
|
|
|
XMLA OLAP Reports in Word / Excel / PowerPoint
18 Apr 2005 12:12:34 -0700
Hi,
Is there any script to have XMLA OLAP Reports in Word / Excel or PowerPoint ?
This is great for printed materials
Regards,
Marco ...
|
drillthrough doubts
Mon, 18 Apr 2005 07:45:03 -0700
hai,
Thank ur kind co-operation.We have one more doubt here.
1.Drillthrough is working fine in cube browser and it is enabled in property
called "is Drillthrough enabled" but when we run a drillthrough query in our
web application it gives error as "The operation has timed out".
2.Is it any method for gener ...
|
Retrive Number of Rows for MDX
18 Apr 2005 06:12:47 -0700
Hi All,
Is there any method to identify the Number of Members or Rows or
Columns before executing the MDX.
Regards,
Mansoor
...
|
