Dataset definition in msmdqlog.mdb

#1

I know that the Dataset in the msmdqlog.mdb represents the Dimensions
in the Cube. Is there any documentation that explains what "each"
dimension is?

For example:

Dataset: 1112233112

This cube has 10 dimensions. Which dimension is represented by the
first byte, which dimension is represented by the second byte, and so
on.

#2

They represent the levels in the dimension.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"mmajorza52" <mike.major (AT) marriott (DOT) com> wrote

Quote:

I know that the Dataset in the msmdqlog.mdb represents the Dimensions
in the Cube. Is there any documentation that explains what "each"
dimension is?

For example:

Dataset: 1112233112

This cube has 10 dimensions. Which dimension is represented by the
first byte, which dimension is represented by the second byte, and so
on.

#3

Hi,

What if one dimension has more then 10 levels?

Thanks,
Vladimir Chtepa

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag
news:OiksvnEIFHA.3332 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

Quote:

They represent the levels in the dimension.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"mmajorza52" <mike.major (AT) marriott (DOT) com> wrote in message
news:1109871797.682824.209120 (AT) f14g2000cwb (DOT) googlegroups.com...
I know that the Dataset in the msmdqlog.mdb represents the Dimensions
in the Cube. Is there any documentation that explains what "each"
dimension is?

For example:

Dataset: 1112233112

This cube has 10 dimensions. Which dimension is represented by the
first byte, which dimension is represented by the second byte, and so
on.

#4

ASCII values are used to represent levles greater than nine. Probably, :, ;,
<, =, >, ...

But I did not have the case yet by myself.

Ohjoo Kwon

"Vladimir Chtepa" <vc.clean_this (AT) diacom-systemhaus (DOT) clean_this.de> wrote in
message news:Ol5qizEIFHA.3536 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Quote:

Hi,

What if one dimension has more then 10 levels?

Thanks,
Vladimir Chtepa

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag
news:OiksvnEIFHA.3332 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
They represent the levels in the dimension.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"mmajorza52" <mike.major (AT) marriott (DOT) com> wrote in message
news:1109871797.682824.209120 (AT) f14g2000cwb (DOT) googlegroups.com...
I know that the Dataset in the msmdqlog.mdb represents the Dimensions
in the Cube. Is there any documentation that explains what "each"
dimension is?

For example:

Dataset: 1112233112

This cube has 10 dimensions. Which dimension is represented by the
first byte, which dimension is represented by the second byte, and so
on.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dataset definition in msmdqlog.mdb

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Dataset definition in msmdqlog.mdb - 03-03-2005 , 11:43 AM

Re: Dataset definition in msmdqlog.mdb - 03-03-2005 , 05:37 PM

Re: Dataset definition in msmdqlog.mdb - 03-03-2005 , 05:58 PM

Re: Dataset definition in msmdqlog.mdb - 03-03-2005 , 09:00 PM