Combining SPICE and DIRECT QUERY in Analysis

[Dom]

Hi,

I am trying to speed up my dashboards by using SPICE for data younger then 2 months and I’m fine using direct query with Athena for older data. I don’t want to load everything into spice as the data goes back years and would use a lot of SPICE memory.
I managed to create the datasets using custom SQL one for the 60 day data with incremental refresh using SPICE and one for older data with DIRECT QUERY.
Now the issue I’m facing is how i can use both datasets in an analysis so when the customer selects a date smaller then two months he will get the data from SPICE dataset and get instant results but if he selects a longer period of time or older then two months he will query also ATHENA by DIRECT QUERY.
Is there a way to do this?
Thank you in advance for any help.
Domenico

[Giridhar.Prabhu]

Hi @Dom

I don’t see any straightforward solution to this problem. I have been thinking about options as well as our data size is growing.

If you try to create a child dataset using your two datasets; since they are different types the Child dataset can only be formed as a SPICE dataset which I guess you don’t want.

One of the options is to duplicate your visuals to work on the two different datasets and dynamically show/hide visuals.

See if the following can work for you.

Hide visual based on filters

Following the steps for free-form-mode conditions and dynamic default values @thomask outlined you will get a result like below. “cSurvey” is a parameter with a Dynamic Default Value. User/Team 2 will load with a default parameter of 2, where User/Team 1 will load with a default parameter value of 1. Example Default Parameter Dataset: [image] You can have multiple condition rules: [image] Optional - You can choose to show the controls/visuals to allow switching surveys. [2022-03-09_06-37-…

Regards,
Giri

[Xclipse]

Hi @Dom

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @Dom

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!