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

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 (AT) diacom-systemhaus (DOT) nospam.de> schrieb im
Newsbeitrag news:OZ8DvhaBGHA.1092 (AT) TK2MSFTNGP09 (DOT) 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 (AT) diacom-systemhaus (DOT) nospam.de> wrote

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


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag news:O13YDozBGHA.2664 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

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 (AT) diacom-systemhaus (DOT) nospam.de> wrote