You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Capacity of Smartview report breaching 250k lines in Excel

Received Response
25
Views
1
Comments
edited Nov 21, 2020 10:17AM in Reporting and Analytics for ERP 1 comment

Summary

When running a Smartview TB Report, if it is filtered by more than 1 segment Eg, Account then fund, it will not run the query as it brings back > 250k lines

Content

I have not suppressed zero values as I want to be able to generate this report on a periodic refresh basis

The purpose of the report is to allow users to readily interrogate from top level TB down to accounts/segment values of interest - down to drill down functionality

Happy to consider other approaches to this - OTBI etc that have worked for others - at our infancy with our learning on this one

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!