trying to use arrow indicators in blox to compare impressions between two different years
Hi Community, Is there a way someone may kindly assist me with how can I use BloX to create red and green arrows indicator to show an increase or decrease in impressions by comparing different year of the same campaign? Please kindly assist š2.5KViews0likes3Comments
Custom code fails to build
Hi all, We created custom code in one of our elasticubes. However, after a week it fails, usually with the following error: "timestamp": "2022-05-24T06:00:31.697Z", "verbosity": "Error", "type": "buildEnded", "message": "Failed to build custom code table: Company Name fuzzy matching; BE#423256 Failed to run Jupyter Notebook cells.\nBE#848116 Cells execution failed with error: '---------------------------------------------------------------------------CustomCodeException Traceback (most recent call last)/tmp/ipykernel_3551/2351106898.py in <module>\n 1 # check for errors in logical sql execution \n 2 if \"error\" in logical_sql_res:\n----> 3 raise err.CustomCodeException(*err.ERROR_IN_LOGICAL_SQL, description=logical_sql_res)\nCustomCodeException: 65001: Error in Logical Sql; {'error': {'status': 401, 'httpMessage': 'Unauthorized'}}\nfull Error Message:{\"header\": {\"msg_id\": \"f6bee5dd-24960211aeb4573fe98a6acf_3551_30\", \"msg_type\": \"execute_reply\", \"username\": \"username\", \"session\": \"f6bee5dd-24960211aeb4573fe98a6acf\", \"date\": \"2022-05-24T06:00:31.381928Z\", \"version\": \"5.3\"}, \"msg_id\": \"f6bee5dd-24960211aeb4573fe98a6acf_3551_30\", \"msg_type\": \"execute_reply\", \"parent_header\": {\"username\": \"sisense_user\", \"session\": \"090d1484-8c54-49a3-800d-59009a087c9d\", \"date\": \"2022-05-24T06:00Z\", \"version\": \"5.3\", \"msg_id\": \"6c8e75a7-80dd-4e69-b917-784dc2624f50\", \"msg_type\": \"execute_request\"}, \"metadata\": {\"started\": \"2022-05-24T06:00:31.267719Z\", \"dependencies_met\": true, \"engine\": \"fa2585fb-5869-4c4c-b442-9c3e8d6639c3\", \"status\": \"error\"}, \"content\": {\"status\": \"error\", \"traceback\": [\"---------------------------------------------------------------------------\", \"CustomCodeException Traceback (most recent call last)\", \"/tmp/ipykernel_3551/2351106898.py in <module>\\n 1 # check for errors in logical sql execution \\n 2 if \\\"error\\\" in logical_sql_res:\\n----> 3 raise err.CustomCodeException(*err.ERROR_IN_LOGICAL_SQL, description=logical_sql_res)\\n\", \"CustomCodeException: 65001: Error in Logical Sql; {'error': {'status': 401, 'httpMessage': 'Unauthorized'}}\"], \"ename\": \"CustomCodeException\", \"evalue\": \"65001: Error in Logical Sql; {'error': {'status': 401, 'httpMessage': 'Unauthorized'}}\", \"engine_info\": {\"engine_uuid\": \"fa2585fb-5869-4c4c-b442-9c3e8d6639c3\", \"engine_id\": -1, \"method\": \"execute\"}, \"execution_count\": 6, \"user_expressions\": {}, \"payload\": []}, \"buffers\": [], \"channel\": \"shell\"}'." Given the 401 error, somehow the custom code cannot access the data. Has anyone encountered the same problem? Our current solution is to restart the Jupyter notebook kernel and run all cells, after doing so the code is working for another week again. If anyone knows how to really fix this, please let me know:) We are running Sisense on-premise with version L2022.2. Thanks!1.7KViews1like1Comment
HTTP Error REST_API Jupyter Notebook
Hi, I am using REST_API from the custom code section and want to query my elasticube but i am getting a below error: {'error': {'status': 401, 'httpMessage': 'Unauthorized'}} I am using the below query: logical_sql_res = sisense_conn.get_logical_sql(query=logical_sql, cube_name=cube_name) results = [x[:] for x in logical_sql_res["values"]] But facing issues, this was working fine last week. Can someone help?1.5KViews0likes1CommentScheduling system
I am looking for a program that can integrate both google sheets and Salesforce together. My main objective is to find an Artificial Intelligence tool that can make a schedule for a film studio based on the info we have provided from the Google sheets. This info will be basic info like what studio that they prefer, which host they prefer, and what green screen they have done. I am hoping that the AI can do those steps itself from the data provided from past studio visits. From there would it be possibly to enter all that data into our Salesforce. I see that this program comes with a lot of widgets, but Iām not sure if it can do those activists. This a very brief description of what I am looking to do, but based on what I have provided do you think there is any chance that this program could do that? Any info will be apricated. Thanks,1.2KViews0likes0Comments
