Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!! I´ve working with twelve reports with many columns each one and I've using almost 7 of them. Basically the idea is to do a clik on a particular date and change all charts and values (in one clic) I left you a sample for better explanation. And How can I realize a better optimization of this. Thanks... If you have question just let me know...
Thanks to all of you for a quick response.
Actually my dashboard works fine.
I was seeing I can use a function like "outer" I think this could very useful.
Thanks all.
Anyone?
Hi Pablo,
This is my offer (schema)
Create a .qvw with calendar, with a button ... when press open your .qvw (with reports) pass date as parm, you .qvw must contains module deploy
Module deploy is based in a sheet excel (object id ej. CH01; user id; route ej. email, export; bookmark id) all this with set of macros
Good luck, Luis
chi, chi Viva Chile¡¡
I may be missing something but it looks like your biggest performance hit is coming from your synthetic table. I'd take care of that before worrying about the clicking on one date.
Here's my suggestion:
1. Place a QUALIFY statement in front of each of the tables. This adds the table name to the beginning of each of your column names and eliminates your synthetic table.
2. Run multiple columns together to create a common key for each table. Forgive me for only speaking English and not using your column names, but an example would be
TABLE_NAME_DATE&','&TABLE_NAME_POLICY_NUMBER&','&AUTOHASHNUMBER128(DATE&','POLICY_NUMBER) AS TABLE_NAME_COMMON_KEY
3. In separate table
RESIDENT LOAD SUBFIELD(TABLE_NAME_COMMON_KEY, ",",1) AS DATE,
CONCATENATE
RESIDENT LOAD SUBFIELD(TABLE_NAME_COMMON_KEY_2, ",",1) AS DATE
This would give you a table with all your keys that you wouldn't have to store, get rid of your synthetic table and give you a common DATE selection across the entire document.
Thanks to all of you for a quick response.
Actually my dashboard works fine.
I was seeing I can use a function like "outer" I think this could very useful.
Thanks all.