vaibhav_j
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Parsing variable length string
I am working with a column in my EC data model which is a variable length string delimited by commas. Here are a couple examples: I would like to separate out (flatten) the string to extract the individual elements from it. What is the best way to accomplish this? Any help/insights are greatly appreciated. Thanks! Example 1: ["Guaranteed Minimum Withdrawal For Life Benefit","Guaranteed Minimum Withdrawal For Life Benefit", "Surrender Charge","Surrender Charge", "Guaranteed Minimum Withdrawal For Life Benefit","Guaranteed Minimum Withdrawal For Life Benefit","Death Benefit","Death Benefit"] Example 2: ["Death Benefit","Surrender Charge"]620Views0likes0CommentsNPE in schema changes model creator - create (55).
I added a custom column in an EC and when I run a 'changes only' build, I am encountering the following error : NPE in schema changes model creator - create (55). Why am I getting this error message and how do I move past it so my EC will build successfully? Note: In the past, I had another EC have the same issue and I ended up deleting the old EC and recreated the exact same cube. The build ran successfully. I could delete and replicate the EC because I did not have many visualizations referencing the cube. However, in case of EC build failure this time, I could impact a lot of exiting reports if I were to delete the EC .1.1KViews0likes0CommentsDashboard Filters
I have a couple questions related to dashboard filters: 1. I am using one filter for the "Country" field and another filter for "States" field. When I select a value in the "Country" filter for instance United States, the values in the "States" filter do not automatically update to show states within the US. Is there a way to achieve this type of filtering ? 2. I have drill down hierarchies established on some visualizations. I am noticing that when I drill into categories, Sisense automatically creates a new filter on the Dashboard. Is there a way to disable the behavior where Sisense automatically creates dashboard filters? Best Regards, VaibhavSolved2.5KViews0likes2CommentsRe: How To Troubleshoot Build Failures (Linux OS)
This is a great article. Thank you Krutika for putting this together. I have encountered this error quite frequently. BE#521691 SQL error: SafeModeException: Safe-Mode triggered due to memory pressure. Your insights on this are much appreciated. Thanks!11KViews0likes0CommentsSchedule "Changes only" EC build
Hello, Is there a way to schedule a "Changes only" build in Sisense? As per the article below, it appears that there is no option to select what type of build I want to run. By default it runs a "Replace All" build at the scheduled time. I wish to run a "Changes only" build at the scheduled time. Any insights? Thanks! https://documentation.sisense.com/w2022-3-x/docs/scheduling-buildsSolved3.6KViews0likes3CommentsRe: Elasticube - "Refresh Schema" error
Diane_Kostka Thanks for your response and the link to the article. Is it OK (safe) to select "Apply" on the alert message and then continue to proceed with the build? Every time I select "Refresh Schema", the message pops up and subsequently the build fails.3.1KViews0likes0CommentsElasticube - "Refresh Schema" error
When I click on the "Refresh Schema" option on an Elasticube, I get the following alert message: Refreshing Schema: Differences detected The following differences were detected between the current schema and the updated schema: <followed by a list of every column in the Elasticube> null 1. Why am I getting this alert message? 2. What does it mean? 3. How can I avoid this alert in the future? See attached screen shot for reference. Thanks!3.2KViews0likes2CommentsRe: Customize Pulse notification alerts
Thank You HamzaJ for your response. Our organization currently doesn't use Zappier for workflow integration but it is good to know that customizing the message is possible like you mentioned. Keeping the thread open for additional insights if there is a Sisense 'out-of-the-box' solution for this. Thanks again!3.1KViews0likes0Comments