dbTalk Databases Forums  

text measures in Analysis Services

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


Discuss text measures in Analysis Services in the microsoft.public.sqlserver.olap forum.



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

Default text measures in Analysis Services - 02-05-2004 , 07:45 PM






We have a requirement wherein we need to display textual
measures stored in the fact table. Obviously i do need any
aggregation in this context.

Does AS support text as measures in cube? If not, are
there any workarounds?

Thanks,
Raghu

Reply With Quote
  #2  
Old   
Rud
 
Posts: n/a

Default Re: text measures in Analysis Services - 02-06-2004 , 03:32 AM






AS supports text measures, but not all clients do (Excel 2000 shows up only
zeros instead of text values). you can view text values in PivotTable from
OWC.
Rud

"Raghu" <Raghunandan_Sugur (AT) ml (DOT) com> wrote

Quote:
We have a requirement wherein we need to display textual
measures stored in the fact table. Obviously i do need any
aggregation in this context.

Does AS support text as measures in cube? If not, are
there any workarounds?

Thanks,
Raghu



Reply With Quote
  #3  
Old   
Brian Altmann
 
Posts: n/a

Default RE: text measures in Analysis Services - 02-06-2004 , 06:16 AM



AS supports only calculated text measures. You can also have textual member properties
However AS does not support stored text measures, and AFAIK there is no workaround
Regards
Bria
www.geocities.com/brianaltmann/olap.html

Reply With Quote
  #4  
Old   
Thierry [MS]
 
Posts: n/a

Default Re: text measures in Analysis Services - 02-06-2004 , 11:06 AM



Hi Raghu,

I'm interested to hear your scenario, we may have a solution for you in
Yukon...

Please feel free to email me directly.
Thanks

Thierry [MS]
Lead Program Manager
Analysis Services Team
SQL BI Product Unit
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Raghu" <Raghunandan_Sugur (AT) ml (DOT) com> wrote

Quote:
We have a requirement wherein we need to display textual
measures stored in the fact table. Obviously i do need any
aggregation in this context.

Does AS support text as measures in cube? If not, are
there any workarounds?

Thanks,
Raghu



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.