MS SQL Server OLAP - How to get dimensions included by a measuregroup?

Author

How to get dimensions included by a measuregroup?

Xie Zheng

2006-03-28, 8:27 pm

Hi all,

Is there possible to get the dimensions included by a measuregroup using
AdomdClient namespace?. I only found this could be easily finished by AMO.

Thanks in advance.

Regards,

Seamus

Akshai Mirchandani [MS]

2006-03-28, 8:27 pm

You can use the MDSCHEMA_MEASUREGROU
P_DIMENSIONS schema rowset:

http://msdn2.microsoft.com/en-us/library/ms126192(SQL.90).aspx

The guid in Adomd.Net is:

http://msdn2.microsoft.com/en-us/library/ms126192(SQL.90).aspx

HTH,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Xie Zheng" < XieZheng@discussions
.microsoft.com> wrote in message
news:C0EA340C-2468-41B9-BE4B- E1014B089E91@microso
ft.com...
> Hi all,
>
> Is there possible to get the dimensions included by a measuregroup using
> AdomdClient namespace?. I only found this could be easily finished by AMO.
>
> Thanks in advance.
>
> Regards,
>
> Seamus

Xie Zheng

2006-03-29, 3:29 am

Hi Akshai ,

The new problem is I cannot add this msolap90.dll to my project. It alwasy
to say "can not register the ActiveX type Library ..\..\...\msolap90.dll"
thought I can regsvr32 it successfully in the command line.

I searched web and have tried to re-install SQLServer2005_ASOLED
B9.msi some
times. but it still appears.

My environment is win2k3 standard and SQL Server 2k5 Enterprise Edition.

It's very appreciated if you would continue to give me hint.

Thanks.

Seamus

"Akshai Mirchandani [MS]" wrote:

> You can use the MDSCHEMA_MEASUREGROU
P_DIMENSIONS schema rowset:
>
> http://msdn2.microsoft.com/en-us/library/ms126192(SQL.90).aspx
>
> The guid in Adomd.Net is:
>
> http://msdn2.microsoft.com/en-us/library/ms126192(SQL.90).aspx
>
> HTH,
> Akshai
>
> --
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Please do not send email directly to this alias. This alias is for newsgroup
> purposes only.
>
> "Xie Zheng" < XieZheng@discussions
.microsoft.com> wrote in message
> news:C0EA340C-2468-41B9-BE4B- E1014B089E91@microso
ft.com...
>
>
>

Akshai Mirchandani [MS]

2006-03-29, 8:27 pm

Where, how and why are you trying to add msolap90.dll to your project? You
should never need to "add" msolap90.dll to a project especially if you are
using ADOMD.NET as implied in your first posting...

You would just use something like this (untested):

//Create a restriction collection to restrict the schema information to
be returned.
AdomdRestrictionColl
ection restrictions= new
AdomdRestrictionColl
ection();
restrictions.Add("CUBE_NAME", Cube);
restrictions.Add("MEASUREGROUP_NAME", MeasureGroup);

//Open and return a schema rowset, given the correct restictions
return Connection.GetSchemaDataSet(" MDSCHEMA_MEASUREGROU
P_DIMENSIONS",
restrictions);

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Xie Zheng" < XieZheng@discussions
.microsoft.com> wrote in message
news:0E22E2D7-9E41-4B4E-85C7- 0B9741FD2414@microso
ft.com...[color=darkred]
> Hi Akshai ,
>
> The new problem is I cannot add this msolap90.dll to my project. It alwasy
> to say "can not register the ActiveX type Library ..\..\...\msolap90.dll"
> thought I can regsvr32 it successfully in the command line.
>
> I searched web and have tried to re-install SQLServer2005_ASOLED
B9.msi
> some
> times. but it still appears.
>
> My environment is win2k3 standard and SQL Server 2k5 Enterprise Edition.
>
> It's very appreciated if you would continue to give me hint.
>
> Thanks.
>
> Seamus
>
> "Akshai Mirchandani [MS]" wrote:
>

Xie Zheng

2006-03-30, 3:26 am

Good Akshai, it works well using ADOMD.net. Thanks once.

"Akshai Mirchandani [MS]" wrote:

> Where, how and why are you trying to add msolap90.dll to your project? You
> should never need to "add" msolap90.dll to a project especially if you are
> using ADOMD.NET as implied in your first posting...
>
> You would just use something like this (untested):
>
> //Create a restriction collection to restrict the schema information to
> be returned.
> AdomdRestrictionColl
ection restrictions= new
> AdomdRestrictionColl
ection();
> restrictions.Add("CUBE_NAME", Cube);
> restrictions.Add("MEASUREGROUP_NAME", MeasureGroup);
>
> //Open and return a schema rowset, given the correct restictions
> return Connection.GetSchemaDataSet(" MDSCHEMA_MEASUREGROU
P_DIMENSIONS",
> restrictions);
>
>
> Thanks,
> Akshai
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Please do not send email directly to this alias. This alias is for newsgroup
> purposes only.
>
>
> "Xie Zheng" < XieZheng@discussions
.microsoft.com> wrote in message
> news:0E22E2D7-9E41-4B4E-85C7- 0B9741FD2414@microso
ft.com...
>
>
>

Sponsored Links