Upload feature on QV dashboard in the accesspoint

[#1]

I am working on a requirement wherein we need to implement an upload feature onto dashboard, which takes .txt or .xls file as input and filters the straight table based on the file uploaded.?

For eg: If we have a list box created on Order ID's field, which has 1000+ records, and i need to see data for specific order id's, rather than entering single order id one by one, can we filter same data by entering the order id's into a file and upload to dashboard, and the dashboard filter's the data for the selected order id's.

Ideas appreciated

[simonpinnow]

Hi Sneha,

perhaps something like this is possible with the dynamic data update feature. But this feature ist only supported on not clustered environments.

With ddu its possible to create new tables in a single season and I think its possible to load data from a file in this new table and to integrate into data model and use as some kind of dynamic filter box. I'm myself don't have enough experience and only know the feature because we use ddu for generating forecast tables in some of our applications.

I'm not sure if its the best way solving your Problem.

Best regards

Simon

[#3]

If the values are connected to the data model, the best way is to enter the data in a source and trigger a reload. There are some extensions in the market.

So the user fill a input field and press a button, then the data is written into a source like a database or flat file and a edx task will trigger a reload of the document.

If the connection to the data model is very simple and only a few records you can write in a database and use direct discovery to display.

Direct input records are only for one user i thing and will removed in the next reload.

Good Luck,

Pravesh

[#4]

Thanks Simon, yes we do not have clustered environment, it is just 1 server.

hi Parvesh,

Yes i needed the upload feature, but i don't want the values to write to db., just the dashboard should filter based on the input file what we uploaded.

This feature would more act like a filter in the access point directly.

[marcus_sommer]

Are there not too many values for the selection you could just use a concatenated string of your values for the search and are there more an inputbox would be useful, too. I hope this will be helpful for you: Re: Selecting a numeric value from a list box using a macro.

- Marcus