| Author |
 Topic  |
|
|
sefer
Germany
105 Posts |
 Posted - 07/20/2006 : 03:29:59
|
Hi,
my dimensions are sorted in RP alphabetically. Is there a way to sort it by a invisible number in AS?
At this moment i solved it so, that i numbered my dimensions from 01 to 09.
thx Sefer |
|
|
admin
1645 Posts |
|
|
vlindap
1 Posts |
Posted - 08/25/2006 : 23:14:30
|
(1) create an attribute (CustomOrder)
(2) Use the business intelligence wizard
(3) Choose specify attribute ordering
Good luck
Pierre
|
 |
|
|
sefer
Germany
105 Posts |
|
|
janbrownhou
USA
12 Posts |
|
|
sefer
Germany
105 Posts |
Posted - 11/03/2006 : 05:03:41
|
I think i found this morning the bug. It seems like a failure from SSAS 2005.
I try to explain how to create the dimension.
1.)Go into your cube create a new time-dimension with the wizard.
2.)Choose only year (year) and id (your time id).
3.)Finish the wizard.
4.)Go to the time-dimension.
5.)drop at first the "month"-attribut from your datasourceview to the attribute under the year
6.)drop now the day, then hour, the minute and so on, like your orderwish.
7.)thats all, create your cube.
The problem is, that their is an unvisible id. This will be generated after adding the attribute. Therfore, you have to put the attributes in your wished order. This order is now used in RP too.
Please notice, it works not in build 126, but in build 128 it works.
regards
Sefer |
Edited by - sefer on 11/03/2006 05:51:45 |
|
|
| |
Topic |
|
Report Portal
Sorting dimensions in RP or AS2005
