|
Home > Archive > MS SQL Server OLAP > November 2005 > presentation of cube data
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 |
presentation of cube data
|
|
|
| I have a cube with a measure contains one aggregation field call hour.
I have two dementions: demention1 contains UName, UAddress, UPhone;
demention2 contains UHistoryDetails
The only reasons that the cube is used here is to take the advantage of
preprocessed data.
Could it be possible to present just dementions data without measure.
The result will be look sth as below:
UHistoryDetails UName UAddress UPhone
xyz Neison, John 3 Rocky Rd 124-555-2323
Thank you very much!
| |
|
| Uhh, in 2000 you would add properties (Address, name, phone) to for example
'user' dimension. Then you could make a measure from those properties (check
property function for more details) and then included them in the results.
MC
"she" <she@discussions.microsoft.com> wrote in message
news:C845F12A-458A-47D5-A597- 8E9FC5E67C8B@microso
ft.com...
>I have a cube with a measure contains one aggregation field call hour.
> I have two dementions: demention1 contains UName, UAddress, UPhone;
> demention2 contains UHistoryDetails
> The only reasons that the cube is used here is to take the advantage of
> preprocessed data.
> Could it be possible to present just dementions data without measure.
> The result will be look sth as below:
> UHistoryDetails UName UAddress UPhone
> xyz Neison, John 3 Rocky Rd 124-555-2323
>
> Thank you very much!
>
>
>
|
|
|
|
|