cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DannyDizzy
‎09-01-2015
  • 28 Posts
  • 2 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: Sorting a character format dimension level with leading numbers

by Fluorite | Level 6 in SAS Web Report Studio
‎03-08-2014 03:56 AM
‎03-08-2014 03:56 AM
The source data to the cube is in oracle and I can´t sort it there. Where could I use the proc sort funcion for a specific level in a dimension, in the cube or infomap? ... View more

Re: Sorting a character format dimension level with leading numbers

by Fluorite | Level 6 in SAS Web Report Studio
‎03-08-2014 03:54 AM
‎03-08-2014 03:54 AM
Is it possible to transform char to num in a cube or infomap for a specific level in a dimension? How and where in that case? ... View more

Re: Sorting a character format dimension level with leading numbers

by Fluorite | Level 6 in SAS Web Report Studio
‎03-04-2014 02:45 AM
‎03-04-2014 02:45 AM
Actually I can't mess with the data order in the source readed into the cube (oracle table). The dimension values are actually the following (as characters): '1', '10', '11', '2', '20'.... about 900 different values. Is it possible to convert theese to numerical in the cube? If not, is it possible to set a fix length and inserting zeroes for the values with less then 3 characters? If not, I have a field with values 'blabla001', 'blabla010', 'blabla002'... is there a format that only takes the last 3 positions in a character field? really messy situation I know ... View more

Sorting a character format dimension level with leading numbers

by Fluorite | Level 6 in SAS Web Report Studio
‎02-26-2014 05:28 AM
‎02-26-2014 05:28 AM
Hi all, another sorting order problem! I have the following setup: Cube -> Infomap -> Web Reaport I have a dimension level "ID and color" (character format) that has values like: '2 blue' '55 green' '105 red' I would like to have them in the order above, instead i get the following order when choosing acending sort order in the report: '105 red' '2 blue' '55 green' Is there any character format that can sort theese kind of values in a numerical way? Or is there any way to do this with a user written format in the cube or some trick in the infomap? /Daniel ... View more

Re: Shy contracting time dimension

by Fluorite | Level 6 in SAS Web Report Studio
‎01-23-2014 06:13 AM
‎01-23-2014 06:13 AM
Noo need! I found the solution! By putting the following expression in the time dimension in infomap studio I surpase the top level in the hierarky (all-members level) and always get expanded levels in the report for the dimension: Descendants(<<Time.Time>>,1 , SELF_AND_AFTER) /Daniel ... View more

Shy contracting time dimension

by Fluorite | Level 6 in SAS Web Report Studio
‎01-23-2014 03:07 AM
‎01-23-2014 03:07 AM
Hi all wise people! I have this setup: cube -> Informationmap -> Report I have a time dimension with a hierarcy like year->month, which I want to show as expanded in web report studio. So when I click "expand all" for that dimension in the report, all is fine... BUT, when a new year is added in the dimensiontable, the new year is not expanded in the report. Is this possible to fix? /Daniel ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎10-08-2013 09:20 AM
‎10-08-2013 09:20 AM
With anger came the solution! The solution is hidden characters, by pressing ALT+255(numbers on the num-pad) one can create a character that looks like a blank but isn't recognized by WRS or the web browser as a blank. This character comes after numerics in the sorting order. By inserting a hidden character in front of the 2-digit numbers in the dimension source-table (in oracle oracle), the sorting problem was no more! ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎10-08-2013 05:32 AM
‎10-08-2013 05:32 AM
Wow! WRS is really stubborn! The leading blank soulution does not work because WRS has a built in STRIP function. It's not in place to remove this funtion from WRS either because we already have a great deal of reports and cannot (don't have time/money) research the implecation on thoose... really a tumb down to the sorting function in group break. Why can I have a data set order in the report but not in the group break?? This issue remailns unresolved and we will go with the 01,02,03... soulution... ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎10-01-2013 04:56 AM
‎10-01-2013 04:56 AM
Yeh, I've played around quite a bit 😃 The best soulution was to insert a zero for the on digit year values, 01 year, 02 years ... 11 years, 12 years. But it was accepted as a plan-B soulution. The result of the ugly plan was preferred (if it works) =). I tried to insert a blank with the prefix function for picture format, but it didn't give any result when used directly in the cube. We will now try to insert blanks in the oracle dimension table. ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎10-01-2013 02:11 AM
‎10-01-2013 02:11 AM
Nope, doesn't work. Seems like the sorting function in the group break doesn't care about the choosen sorting type in the cube or infomap. Always seems to sort the formatted value :smileyangry: We will go with the "ugly" soulution and use blanks in front of the values with only one digit. Thanks Fredrik! The help is always apprecheated! ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎09-30-2013 06:28 AM
‎09-30-2013 06:28 AM
Done that, still doesn't work.. proc format; picture arformat low-high="00 år"; quit; then I applied the arformat to the dimension directly in the cube, the result, still the same... ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎09-30-2013 04:32 AM
‎09-30-2013 04:32 AM
The dimension in cube studio: The details in infomap studio (no option to set any format): The group break in wrs (still wrong sorting): BR Daniel ... View more

Re: The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎09-30-2013 03:59 AM
‎09-30-2013 03:59 AM
Hi again, I now have a numeric value, but still it seems to sort 10 before 2... ... View more

The bad sorting function in group break.

by Fluorite | Level 6 in SAS Web Report Studio
‎09-24-2013 04:00 PM
‎09-24-2013 04:00 PM
Hi! I have a dimension in the group break, the values in the dimensions are 1 year, 2 years ... 14 years. In the group break, you can choose ascending or decending order (not default data set order for some reason...) for theese dimension values. The problem is that dimensionvalues 10 years - 14 years sneaks in between 1 year and 2 years... Is there any way to keep the natrual order 1-14 instead of 1, 10, 11, 12, 13, 14, 2, 3..... Thanks in advance! Daniel ... View more

Re: Which SAS tool works the best for user manual data entry?

by Fluorite | Level 6 in SAS Web Report Studio
‎09-11-2013 08:25 AM
1 Like
‎09-11-2013 08:25 AM
1 Like
Hi, we use as you suggested stored processes with prompts (to limit the user input varaity) with drop down lists opened in WRS. Works fine for us but I dont know the input-limits for this. BR Daniel ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Likes from
View All
Quick links