BookmarkSubscribeRSS Feed
sasrac
SAS Employee
Hi Experts,

I am recieving an error in the WRS regarding the max limit of the crossjoin.

Error messages:There is a problem with the current page.
Error Rendering the Report (Rendering Content)
The number of components in the set exceeds the MAX SET SIZE limit - in the "CROSSJOIN" function.

Is there a way to resolve this?
I have already adjust the tuples from 2,500 to 0 in the WebReportStudioproperties.xml.

Regards,
1 REPLY 1
TSBruce
SAS Employee
You are likely running into a limitation at the OLAP Server level and not WRS. The OLAP Server limits the number of tuples returned by default. The default number is 1000000. You can increase this number by using the following steps:

1. Log into SMC
2. Expand Server Manager>SASApp>SASApp - Logical OLAP Server.
3. Right click on SASApp - OLAP Server and select properties.
4. Go to the Options tab and click Advance Options.
5. On the performance tab, change the value for Maximum number of tuples in a set

Increasing this setting will allow more tuples to be returned. However, enabling the OLAP Server to return more tuples will require more resources and I suspect you may run into memory issues. If so, you can increase the memory of the OLAP Server using the MEMSIZE option.

When you encounter these types of errors, you may also want to take a look at your cube design and the cardinality of your dimensions. Please take a look at http://support.sas.com/kb/19/765.html for documention on how you can calculate result set sizes and the impact cardinality can have.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1927 views
  • 0 likes
  • 2 in conversation