Skip to main content
J
jrajesh10-Marble
10-Marble
July 27, 2018
Solved

Want to include all columns in ThingWorx Analytics Model

  • July 27, 2018
  • 3 replies
  • 1702 views

Hi,

 

I want to include all the columns except not the Goal in the Model. I am forced to create a Filter. Is there a way to include all columns.

 

Thanks and Regards,

Jyothi

Best answer by nsampat

Jyothi,

 

What version of Analytics Server are you using?

 

It sounds like you encountered a known issue, where the Configuration Service was not run after installation of the Extensions.

 

Can you please take a look at this article: https://www.ptc.com/en/support/article?n=CS279917

 

And let me know if that resolves your issue?

 

Regards,

 

Neel

3 replies

N
nsampat17-Peridot
17-Peridot
July 27, 2018

Jyothi,

 

Thank you for your post to the Community.

 

There should be a default filter, called "all_data" available to you for modeling jobs.

 

Regarding excluding the goal, you cannot exclude the goal from a modelling job, as it is required for the creation of the model.

 

Please let me know if this answers your question.

 

Regards,

 

Neel

J
jrajesh10-MarbleAuthor
10-Marble
July 27, 2018

Thanks Neel. But I am not able to see the all_data filter. When I click on Copy Definition from Existing Filter in the Create Filter dialog, I get an error.

 

Errors in Script Logs is

GetFiltersRowCountByDatasetAMS: Error: JavaException: com.thingworx.dsl.exceptions.DSLRequestProcessingException: Execution error in service script [GetFiltersRowCountByDatasetAMS] :: TypeError: Cannot call method "GetFilters" of null (GetFiltersAMS#14)

[message: Execution error in service script [GetFiltersAMS] :: TypeError: Cannot call method "GetFilters" of null (GetFiltersAMS#14)]

N
nsampat17-PeridotAnswer
17-Peridot
July 27, 2018

Jyothi,

 

What version of Analytics Server are you using?

 

It sounds like you encountered a known issue, where the Configuration Service was not run after installation of the Extensions.

 

Can you please take a look at this article: https://www.ptc.com/en/support/article?n=CS279917

 

And let me know if that resolves your issue?

 

Regards,

 

Neel

Terms & ConditionsAccessibility statement