Hi Guys, Is it possible to have Data Profiling done using FE...

[Manoj Chaurasia]

Rajesh

Your code works fine with version 8.2.06 but fails for me with 8.2.07 with the same error. Please open a case with techsupport.

[VisuaLizeFOCUS .]

Yeah I checked that later in the evening.

This is so strange.

I have opened a case with IBI.

Will post what was the issue with Reporting Server

Thanks

[VisuaLizeFOCUS .]

Hi Guys,

Is it possible to have Data Profiling done using FEX code

I used the below code but is returning error :

Code used:

PROFDATA CAR

HOLD FORMAT ALPHA AS TST

TABLE FILE TST PRINT *

END

Error Received:

Reporting Server Error

Reporting Server Error 40000

I know Data Profiling is available in Reporting Server, can we have the same kind of report using FEX Code inside a procedure so that we can play around with it on a dashboard.

WebFOCUS Version: 8207.06

Thanks in advance!!!

[Pawan Vuppala]

rajesh.singh.negi:

 

PROFDATA CAR

HOLD FORMAT ALPHA AS TST

TABLE FILE TST PRINT *

END

 

 

Had no idea about PROFDATA command, good to know but it better work

[VisuaLizeFOCUS .]

Opened a case with IBI.

It seems like it is working for them, IBI Programming team is looking into this issue.

Will keep you guys updated.

[Franciscus van Dortmont]

Try

PROFDATA CAR,,,BRIEF

HOLD AS TST

 

TABLE FILE TST PRINT *

END

 

You wont get MODE and MEDIAN value with this, but works a lot faster

[VisuaLizeFOCUS .]

Hi Frans,

Thanks for your reply.

I tried this code too but the problem is

PROFDATA CAR

works fine but it dosent hold the data and returns REPORTING SERVER ERROR 40000.

But this is working in older version of WebFOCUS.

I am running this code on WebFOCUS 8207 version.

Let me know if you are running this code in same version.

Thanks

[NYCBabak .]

Have you tried this code on the Reporting Server side instead of the WebFOCUS side It seems to work when you create the fex on the app directory.

[VisuaLizeFOCUS .]

It works on Server side but it fails to hold the data.

Again giving REPORTING SERVER ERROR 40000.

I am using WebFOCUS version 8207.

[Franciscus van Dortmont]

Did you try my example In my example it holds the data in file TST.

[NYCBabak .]

I tested wf_retail with the original code and it does in fact hold the tst file and it returns a report but only if I run it on the reporting server. I wonder if the size of the underlying table has anything to do with the error youre getting.

[VisuaLizeFOCUS .]

Frans

I tried that code already.

Thanks

[VisuaLizeFOCUS .]

As per IBI this should not be happening and they are looking into it.

[Pawan Vuppala]

Pretty neat! Thanks for sharing!!

 

 

 

frans:

 

PROFDATA CAR,BRIEF HOLD AS TST TABLE FILE TST PRINT * END

[John Gelona]

Ive been using the FOCUS languare since 1985. I dont ever use HOLD FORMAT ALPHA, have you tries to SET HOLDFORMAT ALPHA before your PROFDATA statement