I think, we dont have direct approach to split 1 report into 2500 reports.
(We call this approach as "Page break" in COGNOS).
Thanks for reply ! Is there is any way to do this in tableau? or by power shell scripting?
there are options but i assume they are not supported by tableau.
if you have Tableau Server you can combine extraction from xml with tabcmd
1) If you were to open a twb file in a text or xml editor you will find a block of text that looks like this -
<column caption='Your Parameter' datatype='string' name='[Your Parameter]' param-domain-type='list' role='measure' type='nominal' value='Option 1'>
<calculation class='tableau' formula='Option 1' />
<member value='Option 1' />
<member value='Option 2' />
<member value='Option 3' />
2) Using the list you get from the xml and combine with Automating PDF Exports with Filters Using Tabcmd | Tableau Software you can use powershell to loop through and print each parameter to pdf.
Beware this will put a heavy load on the server so only do this out of hours.
This may be possible option but how i combine xml with tabcmd commands?
you can use xpath within powershell to loop through the xml. - How to read xml files with PowerShell
you can them use tabcmd within the powershell to produce the pdf exports. (you will need a variation on this - Automated PDF Email Distribution Of Tableau Views Using PowerShell And Tabcmd )