Piotr_qbeeq
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Sisense User Password Update
Hi KHConsult If those models are in the Live Model mode and were published correctly the new credentials should be saved and working. Please additionally have a look at the 'Share' option and check if all dedicated users/groups are included there. Always here to help, Piotr from QBeeQ QBeeQ - Gold Implementation and Development Partner www.qbeeq.io1.4KViews0likes0CommentsRe: How to Refresh the Data source in Elasticube
Hi Learner The Excel file as a datasource is stored on your Sisense server. Please go to 'Connection Settings'->'Change Connection' on your table in the EC then try to upload again the latest version of your Excel file and select it. Your EC table should be now updated with schema and data. Always here to help, Piotr from QBeeQ QBeeQ - Gold Implementation and Development Partner www.qbeeq.io2.7KViews0likes0CommentsRe: Data types for Live Data Source
No, you can't change a data type in the Live Model mode. Please try to convert the [session_date] field from datetime to date in Redshift. If it won't work try to convert into varchar (e.g. YYYY-MM-DD) - Sisense should map the right data type. I assume you won't be using this field for date based filtering (year/month/day/dynamic period) but just as dimension in your visuals.3KViews1like0CommentsRe: Data types for Live Data Source
Hi bpeikes From the L2021.9 version the 'date' data type is available in Sisense. Please refer to: https://sisense.dev/reference/rest/v2/data-types.html You can also try to convert your date column to varchar/string in Redshift to get just the date. Always here to help, Piotr from QBeeQ QBeeQ - Gold Implementation and Development Partner3KViews1like2CommentsRe: Create a widget filter based on dashboard filter
Hi Akhila, Are you looking for YTD, MTD or related? If so these articles below might be interesting for you: https://support.sisense.com/kb/en/article/ytd-function-reference https://support.sisense.com/kb/en/article/calculating-ytd-with-variable-start-and-end-dates-of-the-year-academic-calendar https://support.sisense.com/kb/en/article/date-analysis-yoy-mom-wow-ytd-mtd3.1KViews0likes0CommentsRe: Elasticube destination questions
I'm not 100% sure but you can try to use the REST API for that. On your external environment side there should be made a piece of code which would be able to connect to a Sisense ECube just by REST API. Please look at those calls below: 1. (0.9) query-rest-controller -> [GET] /datasources/{cubeName}/sql "Execute sql" - this should be for data retrieving, 2. (1.0) authentication -> [POST] /authentication/login "Authenticate" - this should be for auth. This is documentation for REST API: https://sisense.dev/guides/rest/ Hope it is helpful.1.5KViews0likes0CommentsRe: How to create a table with a range of dates?
Hi TomerA If you're running Sisense on Linux you can try to use the Custom Code feature to generate a calendar. Please select 'Custom' - > 'Add Custom Code': then click on 'Create a Calendar': you can configure your calendar by given 'Start Date' and 'End Date': After you click 'Done' additional table will be created as your calendar (based on config in the example above, the calendar will be created in the range from 2020-01-01 to the current date). You can use such date dimension table as you like in your EC structure transformation. There are some more fields you can find useful such as [DayOfWeek]. If you are running Sisense on Windows you please follow this article: https://support.sisense.com/kb/en/article/date-dimension-file3.4KViews4likes2Comments