| T O P I C R E V I E W |
| sefer |
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 |
| 5 L A T E S T R E P L I E S (Newest First) |
| sefer |
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 |
| janbrownhou |
Posted - 11/02/2006 : 07:50:30
FYI: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olapdimensions_rowset.asp is no longer on the Microsoft site. |
| sefer |
Posted - 09/05/2006 : 04:26:49
Hi,
i explain my problem with this pic. Please look at it.
http://h572642.serverkompetenz.net/download/bug/23.jpg
regards,
Sefer |
| vlindap |
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
|
| admin |
Posted - 07/24/2006 : 21:43:02
sefer,
What you are asking to do is possible to do with DIMENSION_ORDINAL attribute:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olapdimensions_rowset.asp
However, it is not clear why alphabetical order does not work for you. Can you please explain your situation? |
Report Portal
