on 07-29-2014 6:32 PM
Hello,
I am using Dashboard Design 4.1 SP1.
First, I adjusted the Maximum number of rows to 40000.
Then, when I tried to use 32168 rows in excel, Dashboard crashed and now I cannot load the xlf file, it hangs.
I read previously that 512 rows is best practice, but what if I need to use thousands of rows? Is there a way to achieve this?
Thank you,
George
Obviously the dashboard wont support & 100% it will crash when dealing with huge data. As you are aware that dashboard is meant only to display summarized information not the detailed data.
What is you source ? you can set the filters in the source level or if you are using only the spreadsheet then as a workaround i would suggest you to create a webi report and import the webi to the dashboard. This is more flexible rather the playing with the pain.
--SumanT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We need a basic sales report: Products x Customers x Salesmen x Months. This can hardly be below few thousand rows.
The value for us is in the dynamic filtering that Dashboard offers to be done by the users when the pdf files were exported to and created.
Can I use Dashboard for this purpose?
If not, for which applications would I use Dashboard?
Hi George,
You could achieve using 40000 rows of data in the dashboard by creating a Webi report.
This webi report is published as a BI web service which can be used in the Dashboard.
The dashboard can be published in different formats Eg: Flash file, pdf, ppt, word irrespective of the datasource/connection being used in it.
Refer to the following link for creation of the above.
Let me know if this helps.
Regards,
Noopur
Apply the logic's in webi and create the report, then embedded the report into dashboard using Live Office or web service connection. But not again the 40000 records into the dashboard. Use prompts are filters to make the data at summarized level.
Yes then you can export them into the PDF format. But make sure that server details are configured in user machine's host entry.
All the best!!!
Hi,
How many records are you going to show on the dashboard? 32K? Thats too much for user to grasp.
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.