Summary of Data - Is using references the best/only way?

building reports webintelligence
1

Hi,

I am querying many months of data. What I have done is create 13 queries, one for each month, then got the data I want. I want a summary page, where I can have the totals of certain fields/sums. The only way I know of doing this is to create a new report, add a table, then go find all the fields I want within the 13 queries and add references to each cell of data that I want, then put the references in the summary table I made. The process is very labor intensive, but it does provide what I want. Is there any other way to save time? I’m still a bit green at Webi, so any help I can get would be appreciated.

Thanks,

1 Like
2

why 13 queries and not 1 ?

3

Because I want data from 9-2021 and 8-2021, 7-2021 etc…

For my filter in one query I have: Most recently completed Month End, in the next query, I have Most recently complete month end-1, so on and so forth.

I don’t see a way to get the data I want in one query. If that is possible, please let me know.

4

if it is all from the same datasource, get all the data in 1 query and a do the filtering/calculations in WebI
or
make 1 query and add all of your 13 queries combined with “union”
https://datamgmt.ucsc.edu/help-training/infoview-help/how-do-i/advanced-report-writing/multiple-queries/union-queries.html

1 Like
5

What date options do you have available?

Do you have access to the Semantic Layer? It’s possible to create predefined conditions to support your query, or make dynamic objects to support this - there’s a relative dates sticky at the top of the semantic layer board which I wrote many years ago.