MS SQL Server OLAP - Direct Dimension Query

Author

Direct Dimension Query

Vladimir Chtepa

2005-12-20, 8:25 pm

Hi,

We can run MDX query direct against dimensions
For example

SELECT [Date].[Calendar Year].[All Periods].CHILDREN ON 0, {} ON 1 FROM
[$Date]

How to obtain the same result with the schema rowset query?
What rules are valid for such use cas?

Thanks,
Vladimir Chtepa

Vladimir Chtepa

2005-12-20, 8:25 pm

Hi,

I have discovered it self.

Like MDX instead of CUBE_NAME we can write $DIMENSION_NAME in the mdschema
query.

"Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> schrieb im
Newsbeitrag news:OZ8DvhaBGHA.1092@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> We can run MDX query direct against dimensions
> For example
>
> SELECT [Date].[Calendar Year].[All Periods].CHILDREN ON 0, {} ON 1 FROM
> [$Date]
>
> How to obtain the same result with the schema rowset query?
> What rules are valid for such use cas?
>
> Thanks,
> Vladimir Chtepa
>
>
>

Akshai Mirchandani [MS]

2005-12-22, 8:25 pm

Note that DB dimensions can only be queried directly by a DB Admin... So a
non-DB-admin user may run into issues if you build this into your solution.

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.

"Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> wrote in message
news:%236%230vpaBGHA
.636@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I have discovered it self.
>
> Like MDX instead of CUBE_NAME we can write $DIMENSION_NAME in the mdschema
> query.
>
>
> "Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> schrieb im
> Newsbeitrag news:OZ8DvhaBGHA.1092@TK2MSFTNGP09.phx.gbl...
>
>

Vladimir Chtepa

2005-12-28, 11:24 am

Could you please exactly describe, what role schould accont belong to?

"Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> schrieb im
Newsbeitrag news:O13YDozBGHA.2664@TK2MSFTNGP15.phx.gbl...
> Note that DB dimensions can only be queried directly by a DB Admin... So a
> non-DB-admin user may run into issues if you build this into your
> solution.
>
> 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.
>
> "Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> wrote in message
> news:%236%230vpaBGHA
.636@TK2MSFTNGP10.phx.gbl...
>
>

Akshai Mirchandani [MS]

2005-12-28, 8:24 pm

When you create a Role inside a Database and give that role "Administrator"
permission, you are making members of that role administrators of that
database.

The Server Administrator role is separate and members of the Server
Administrator are modified by editing the Security properties of the server.

(Of course, note that this all applies to AS 2005 only).

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.

"Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> wrote in message
news:%23u7ABn8CGHA.1180@TK2MSFTNGP09.phx.gbl...
> Could you please exactly describe, what role schould accont belong to?
>
>
> "Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> schrieb im
> Newsbeitrag news:O13YDozBGHA.2664@TK2MSFTNGP15.phx.gbl...
>
>

Sponsored Links