Diane_Kostka
Sisense Employee
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Elasticube - "Refresh Schema" error
Details on the specific error can be found in this article To void this alert moving forward, I would recommend proactively refreshing the table connectivity settings in the elasticube once any changes are made on your database end. Hope that helps!3.1KViews0likes1CommentRe: What does "Query cube from local storage" do if you are a single-node instance?
Hello! The "Query cube from local storage" toggle is not relevant for single node, since, as you correctly guessed, single node has no shared storage and already stores all elasticubes locally. We are working to hide this toggle for single nodes in the UI moving forward, "Store ElastiCube data on S3" would be enabled to save your ElastiCubes on S3 if you have configured it in your config.yaml files that were used when setting up Sisense. The storage location is also reflected(cannot be changed) from within Configuration manager->Management. I do agree that the configuration options today represent all possible options in the app and are not filtered to be environment specific or dependent on other configuration choices. This is something that we plan to fix in the future to make the data groups UI more intuitive. Thank you for that feedback! - Diane2KViews0likes0CommentsRe: Retrieving only last weeks data using Custom SQL Query for Generic JDBC mongo connector
Hello! You would need to use the mongo supported function in the import queries to achieve the equivalent of the SQL function. Please refer to this list of MongoDB supported functions Hope that helps! - Diane1.7KViews0likes0Comments