FmtValue Missing In XML

From: Joe Genshlea (joegensh_at_yahoo.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 11:59:51 -0700

Hi,

I am using XMLA v1.0
Client: ColdFusion MX
Server: AS 2000 SP3

Symptom:

The XML returned by the server does not include the FmtValue property for
each Cell element which is causing all kinds of exception processing in my
code. Is this bug or am a I missing something?

Joe

MDX:

with
Set [Delta Ordered State] as 'Order ( {[Geography].[State Nm].members},
[Measures].[Change From Q1 2003] ,BDESC ) ' Member [Measures].[2004 Q1] as
'( [Business Close].[All Business Close].[2004].[Quarter 1] ,
[Measures].[Adj Loan Count])'
Member [Measures].[2003 Q1] as '( [Business Close].[All Business
Close].[2003].[Quarter 1] , [Measures].[Adj Loan Count])' , FORMAT_STRING =
'#,#'
Member [Measures].[Change From Q1 2003] as ' [Measures].[2004
Q1] -[Measures].[2003 Q1]' ,FORMAT_STRING = '#,#'
Member [Measures].[Delta Rank] as 'Rank ([Geography].currentmember, [Delta
Ordered State] ) ' ,FORMAT_STRING = '#,#'
Select { [Measures].[Delta Rank] ,[Measures].[2004 Q1] ,[Measures].[2003 Q1]
, [Measures].[Change From Q1 2003]} on 0, [Delta Ordered State] on 1
from FHA_GE0G where ([Business Close].[All Business Close].[2004],[Loan
Purpose].[All Loan Purpose].[Purchase],[Property Type].[All Property
Type].[Resale], [Gift Letter Source].[All Gift Letter Source].[Non Profit
Org])

Relevant Pages

  • RE: Secure Ldap call not working due to IUSR/IWAM permissions?
    ... I'm assuming that some of the settings I changed before installing sp3 is ... Secure Ldap call not working due to IUSR/IWAM permissions? ... Windows Server Infrastructure ...
    (Focus-Microsoft)
  • Re: News post problem
    ... Are you specifying a server name or its IP address? ... If the problem is a symptom of responsiveness by your DNS you ... a connection to be established via PPPoE, ... If you can pre-establish a connection with the command window ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Unable to register msmdpump.dll
    ... Since Enterprise Edition of Analysis Services SP3 allows you to use HTTP ... connections to query AS and have AS on a different box than IIS. ... Make sure Analysis Server SP3 is installed on the server machine. ... the clients connecting will have to have SP3 client upgraded by running ...
    (microsoft.public.sqlserver.olap)
  • FillSchema works on one machine but not another???
    ... My application server is a Windows 2000 Server (SP3) computer with MS ... I use Red Gate Software SQL comparison tools and have verified that the ... files on both machines are identical. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: sp3 + O.E. 6
    ... Comcast's web based server. ... I have since uninstalled sp3 and used the disk to reinstall it. ... If I could develope an interface with newsgroups, I would not have to keep ... WinXP SP3 - Read all prerequisites for a successful installation ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)