Home > Archive > MS SQL Server OLAP > March 2006 > ADOMD.Net & GetSchemaDataSet, where are my perspectives?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ADOMD.Net & GetSchemaDataSet, where are my perspectives?
Jéjé

2006-03-23, 1:32 pm

Hi,

I'm using the GetSchemaDataSet function to retrieve my metadata.
This return my cube list, but not the perspectives!

how to retrieve my perspectives?

My code:
Dim dsCubes As System.Data.DataSet

Dim restcoll As New AdomdRestrictionColl
ection

restcoll.Add("CATALOG_NAME", sDatabase)
dsCubes = ocn.GetSchemaDataSet("MDSCHEMA_CUBES", restcoll)

Return dsCubes


thanks.

Jerome.


Joerg

2006-03-23, 8:37 pm

Hello Jeje,

sorry, this is not helpful I tried your code and worked.
Did you try to query measure groups?

Jörg


"Jéjé" wrote:

> Hi,
>
> I'm using the GetSchemaDataSet function to retrieve my metadata.
> This return my cube list, but not the perspectives!
>
> how to retrieve my perspectives?
>
> My code:
> Dim dsCubes As System.Data.DataSet
>
> Dim restcoll As New AdomdRestrictionColl
ection
>
> restcoll.Add("CATALOG_NAME", sDatabase)
> dsCubes = ocn.GetSchemaDataSet("MDSCHEMA_CUBES", restcoll)
>
> Return dsCubes
>
>
> thanks.
>
> Jerome.
>
>
>

Jéjé

2006-03-23, 8:37 pm

you are right!!!

I have missed a filter in my code which exclude perspectives!!!! :-)

sorry for the Kb taken by these posts ;-)


"Joerg" <Joerg@discussions.microsoft.com> wrote in message
news:09A63137-487C-40F5-B339- 3E64286E5D9C@microso
ft.com...[color=darkred]
> Hello Jeje,
>
> sorry, this is not helpful I tried your code and worked.
> Did you try to query measure groups?
>
> Jörg
>
>
> "Jéjé" wrote:
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com