OLAP/FP2003

[ThomasGREECE]

Hey,
I am using FP2003 to publish in local Intranet. I insert data through OLAP/Analysis Services to Web components (Pivot tables).
Some fields returns #NUM! (obviously from cube results). How can I filter out such data?
Thanx in advance

 

[clintonG]

Garbage-In? or Garbage-Out? (GIGO)

Either direction will require scripting to validate the operation.
Client-side validation to resolve to garbage-in and server-side
to resolve garbage-out.

I think it a good idea to post to a SQL newsgroup as the SQL
admins and developers have likely learned to solve this type of
GIGO issue and can suggest an optimal solution.

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

Hey,
I am using FP2003 to publish in local Intranet. I insert data through

OLAP/Analysis Services to Web components (Pivot tables).