dbTalk Databases Forums  

Dimension names > 24 chars in AS2K

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


Discuss Dimension names > 24 chars in AS2K in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
RuiDC
 
Posts: n/a

Default Dimension names > 24 chars in AS2K - 06-23-2005 , 03:13 AM






We have a business requirement to have dimension names on reports
coming back as > 24 characters (which is not permitted by AS2K - except
via DSO - which is ugly and has many risks) or to be able to show a
different name for a dimension on the Grid to what is in AS2K.


So our dimension name:


Owner.Bus Desk Hist


would become something like


Historical Owner By Business Desk


or re-labeled from AS2K on the way to become simply:


Owner By Desk


We are using 3rd party front-end grid (ProClarity Web) which does not
seem to provide the ability to achieve this or to use (for example) the
description field in place of dimension name.


At the moment, the API returns only the Page HTML as a string, limiting
my options to a search/replace.


Has anybody dealt with this issue or can anyone suggest a better way?



Reply With Quote
  #2  
Old   
Chris Webb
 
Posts: n/a

Default RE: Dimension names > 24 chars in AS2K - 06-24-2005 , 03:32 AM






Hi Rui,

I suspect it's not going to be possible to do what you want, although it
looks like the 24 character limitation doesn't exist in AS2005 if you want to
wait for that...

Regards,

Chris

--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"RuiDC" wrote:

Quote:
We have a business requirement to have dimension names on reports
coming back as > 24 characters (which is not permitted by AS2K - except
via DSO - which is ugly and has many risks) or to be able to show a
different name for a dimension on the Grid to what is in AS2K.


So our dimension name:


Owner.Bus Desk Hist


would become something like


Historical Owner By Business Desk


or re-labeled from AS2K on the way to become simply:


Owner By Desk


We are using 3rd party front-end grid (ProClarity Web) which does not
seem to provide the ability to achieve this or to use (for example) the
description field in place of dimension name.


At the moment, the API returns only the Page HTML as a string, limiting
my options to a search/replace.


Has anybody dealt with this issue or can anyone suggest a better way?



Reply With Quote
  #3  
Old   
RuiDC
 
Posts: n/a

Default RE: Dimension names > 24 chars in AS2K - 06-24-2005 , 03:39 AM



Yep,
thanks Chris, i'd seen it in 2K5, but it's just going to be around too late
for us!

I'm waiting to hear what ProClarity Can suggest on their end.

Cheers,
R

"Chris Webb" wrote:

Quote:
Hi Rui,

I suspect it's not going to be possible to do what you want, although it
looks like the 24 character limitation doesn't exist in AS2005 if you want to
wait for that...

Regards,

Chris

--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"RuiDC" wrote:

We have a business requirement to have dimension names on reports
coming back as > 24 characters (which is not permitted by AS2K - except
via DSO - which is ugly and has many risks) or to be able to show a
different name for a dimension on the Grid to what is in AS2K.


So our dimension name:


Owner.Bus Desk Hist


would become something like


Historical Owner By Business Desk


or re-labeled from AS2K on the way to become simply:


Owner By Desk


We are using 3rd party front-end grid (ProClarity Web) which does not
seem to provide the ability to achieve this or to use (for example) the
description field in place of dimension name.


At the moment, the API returns only the Page HTML as a string, limiting
my options to a search/replace.


Has anybody dealt with this issue or can anyone suggest a better way?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.