Bigquery can't retrieve data but can see schema due to wrong dataset location
I can retrieve all datasets and tables from Bigquery but when trying to actually get the data (preview or executing custom sql). It happens for Live connection and Elasticube. I use a json service account file to authenticate and withing Google Cloud logging I see that Sisense is trying to fetch the data from US which is not the location the dataset is. I don't know how to fix it. Google cloud log: when trying to fetch data: "Not found: Dataset PROJECT_XX:dataset_xx was not found in location US"1.4KViews0likes3Comments
Name Type Field Returned as { "Name": "Text" } instead of just Text
All of a sudden, all the name type fields/columns are now returned as { "Name": "John Doe") instead of John Doe. Data source is all from Salesforce tables. Is this a connector issue? It was ok before today. Thanks.903Views0likes1Comment
Connection to BigQuery
Hi to all. I am a brand new Sisense user, never used before, and sorry if this question is too basic. I am trying to connect to our BigQuery database and I was reading that I need to copy as service account, therefore I will need the key .json file and, accordingly the documentation I need to copy this json file into the sisense server, is there a way to do this using the GUI interface instead copying physically into a folder on the sisense instalation path. Best Regards.1.4KViews0likes1Comment
Remove Accordion button symbol with a hover over from Widget Title Bar
I am using the Accordion plugin and it works great. My only issue is that it places a symbol with a hover over in widget title. Great idea but it causes the widget title to look garbled and hard to read. I would like to remove this in the widget title. Thank you1.1KViews0likes0Comments,Sisense doesn't update cached table from RedShift
Hi there , We've had a table called jora.historical_email_engagement that was connected to Sisense Periscope yet stopped updating the data from 28th June onwards. The original table source is updated regularly and can be queried via SQL workbench. However, the problem is that Sisense reports are showing that the table was updated as usual and haven't experienced any errors. Please help me in resolving this. Thank you.815Views0likes0Comments
Sisense Bigquery Integration not loading all rows in dataset
Hi there, We have a problem with a dashboard which is showing incorrect summary data. We have validated that running the query on the raw data gives the correct results but for some unknown reason, Sisense appears not to be loading all the rows from the source data and so gets the aggregate calculation wrong. The problem is intermittent but occurs frequently which means we can't publish the dashboard because the numbers can be wrong. We can't share examples because of privacy reasons but to describe the dataset, we have a table containing a set of events with timestamps for specific users. In BQ we can see for one user they have 25 events but in Sisense only 2 events are showing. We've checked that it's not timestamp conversions of any obvious data processing error. It seems to be isolated to a problem with the connection. Does anyone have any advice on debugging a biquery connection? Thanks960Views0likes0CommentsCronjob to copy files from local to K8
Hi All, Currently I am using the following kubectl cp /home/ftpifx sisense/`kubectl -n sisense get po -l 'app=management' | awk 'END { print $1 }'`:/opt/sisense/storage/data/informix/ command to copy files between our local system and the storage pod. However, we want to automate the run of this. We tried creating a bash script and adding this to the Linux crontab, but this doesn't run. Is there another way to run this command automatically?Solved3.6KViews0likes2CommentsWhat is the best way to query number of customers subscribed during a particular time period
Our dashboard users have a specific request; they want to see data within a particular time period Below is how my dataset looks like (dates are mm/dd/yy). User request - To see how many customers were subscribed within a time period regardless of their current status. i.e. even if their current status is cancelled as long as they were active during the user-provided time period they should be counted Example - User selects time range to be 01/01/2020 - 03/31/2020. Running a query on below data set should return count of 3. [CUST1 as they cancelled after 03/31/2020, CUST3 as they signed up before 01/01/2020 but are still active, CUST5 as they were active for some point during that period] Problem - While I can write a SQL query with abundant where clauses to achieve this, we want a self-service automated way i.e. we want users to just provide us the time range and get the number. How do we achieve this in Sisense? I am also open to other tools, changing the data model design and other options. Customer ID Subscription Start Date Subscription End Date Subscription Status CUST1 10/11/2019 4/12/2020 Cancelled CUST2 1/12/2020 Active CUST3 5/1/2019 Active CUST4 6/7/2012 7/8/2012 Cancelled CUST5 1/12/2020 3/14/2020 Cancelled CUST6 4/12/2020 Active1.7KViews0likes1Comment
Issue in Flattening JSON objects in Jira
We actually have to flatten the column which has JSON kind of representing data in the sisense elastic cube which was imported from Jira data source through JDBC connector. For this we have tried the JSON_Value() to split JSON consisting column to flatten the data, but it is giving an error like JSON_Value(string,string) is not supported. We tried this using link https://support.sisense.com/kb/en/article/flattening-json-objects-in-sql-server#:~:text=Question%3A%20In%20instances%20where%20tables,these%20objects%20into%20individual%20fields Do we have any solution for this before or after getting the data in to the cube, if so, how? Is there any function like JSON_Value() that supports for Jira Data1.3KViews0likes0Comments
