#53573 - 05/02/17 05:13 PM
GridView Query
|
Adagio Guru
Registered: 06/05/07
Posts: 126
Loc: Los Angeles, CA
|
Hi,
From a First view results, is there a way to create a new second view and query from the first views result?
Example: First view result have LY's sales details. On the second view, I want to get let's just say March of LY's sales from the first view.
Basically using the First view as my table for the second view. Is that possible?
Marlon
|
Top
|
|
|
|
#53574 - 05/02/17 05:20 PM
Re: GridView Query
[Re: MarlonMF]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
Yes.
ExcelDirect the first View, then create a GridView View on the resulting Workbook.
This is an excellent way to process large SalesAnalysis databases.
_________________________
Andrew Bates
|
Top
|
|
|
|
#53575 - 05/02/17 05:34 PM
Re: GridView Query
[Re: Retired_Guy]
|
Adagio Guru
Registered: 06/05/07
Posts: 126
Loc: Los Angeles, CA
|
Hi Andrew,
That is what I was trying to avoid. To export it first and then run another view from it. I can see that there will be an extra step if I want to update the first view (excel direct).
Would this be something that can be added in the future GridView release? Using the one view to be the table of the other view?
Marlon
|
Top
|
|
|
|
#53576 - 05/02/17 05:38 PM
Re: GridView Query
[Re: MarlonMF]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
What would change last year's sales details?
_________________________
Andrew Bates
|
Top
|
|
|
|
#53578 - 05/02/17 05:49 PM
Re: GridView Query
[Re: Retired_Guy]
|
Adagio Guru
Registered: 06/05/07
Posts: 126
Loc: Los Angeles, CA
|
Nothing really. I just want the report to be dynamic.
Let's say today, I want to run 2014 sales, and then later 2015 and then so on... With your solution, I'll have to have 2014 spreadsheet and then 2015 Spreadsheet and so on... To use the 2014, I have to switch the views to look at 2014 spreadsheet. And switch again for the 2015.
The solution I have in mind is that the primary view will get the data directly from Adagio Tables which have tons of records. Using the primary views result (from tons of record to a constricted records), generate another view. My thought on this is that I'm trying to save the time from reading the whole table from Adagio just to get the second view.
Does it make sense?
Marlon
|
Top
|
|
|
|
#53597 - 05/03/17 11:32 AM
Re: GridView Query
[Re: Douglas Dickie]
|
Adagio Guru
Registered: 06/05/07
Posts: 126
Loc: Los Angeles, CA
|
Douglas:
Adagio Order Entry 9.2A (160707), historical data. Clean data is really ideal. 1.7M+ records, 8 years worth 200k+ per year average
I know you folks are trying to find a solution to this one specific example that I have and thank you for that.
But I think that being able to use a view as a table can be useful in some other ways too. Of course, I can't think of anything right now.
Anyway, I appreciate your input.
Marlon
Edited by MarlonMF (05/03/17 11:33 AM)
|
Top
|
|
|
|
#53599 - 05/03/17 11:57 AM
Re: GridView Query
[Re: MarlonMF]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
Hi Marlon,
Just as you can use an Excel Workbook as a data source, you can also use an GridView View as a source as well. You just have to save the data with the View.
However, it can take a while to load a big View too - nothing comes for free.
If you want a systematic approach to this, create a View with the lowest level of detail you need. The create progressively higher summarized Views of the same data - daily, monthly, quarterly, yearly. Have a set of Views that only refresh the current month data.
Append the current month to the other tables when you want to see the whole current data set.
You might also find that processing this data from the SalesAnalysis transaction table is faster, as it is already partly normalized. Sometimes the SalesAnalysis Statistics table has the data you need, and it only contains one record for each day.
_________________________
Andrew Bates
|
Top
|
|
|
|
#53606 - 05/03/17 12:51 PM
Re: GridView Query
[Re: Softrak Support]
|
Adagio Maestro
Registered: 06/26/08
Posts: 1157
Loc: Langley, BC
|
You can also read all the data in one view and put them in different columns depending on the date.
_________________________
Patricia Balbuena Cotlear AP SMART SUPPORT 236 991 3060
|
Top
|
|
|
|
|
1 registered (Lauren Stief),
146
Guests and
0
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14449 Topics
70594 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
|
|
|
|
|