BookmarkSubscribeRSS Feed
0 Likes

The Data Base I'm using only has 125,000 rows. Each row has an individual ID.

I would like to use a Text Input prompt for my report but SAS VA 7.3 cannot process such a large set of data.

I can, nonetheless, type in an ID but it will only be taken into acount if I "do" something else like change to another section.

 

I would very much like to enter my ID choice to filter my graph without having to change section.

 

Thanks in advance.

 

2 Comments
Madelyn_SAS
SAS Super FREQ

There are some workarounds for this limitation using parameters. Is the text input control in the report prompt area? If so, you could try the following:

  1. Create a parameter based on the data item you are using in the text input control.
  2. With the text input control active, click the Roles tab.
  3. Select the data item for the Category role and the parameter based on the data item for the Parameter role.

 

AnnaBrown
Community Manager
Status changed to: Suggestion Implemented

In SAS Visual Analytics 7.5, you can use the "Override system data limit" option.

 

To modify the maximum rows for all instances of this object type, check out the configuration property on the report data service, called "maxRowsLookup." See "maxRowsLookup.textInput" here.

 

In SAS Visual Analytics 8.3, you can use High-Cardinality Thresholds for Objects to override the text limit (See related doc).