ScheurK
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Corrupted data cube
So I made a ticket a while ago and they gave me instructions: 1) Go to Sisense server: Run the command: kubectl -n sisense exec sisense-mongodb-xxxxxxxxxx -it -- bash (where sisense-mongodb-xxxxxxxx is the name of your mongo pod, you may type the command out and after ‘sisense-mongodb’ press Tab button, it should complete the name. If this is not working you may find the mongo pod name by using command kubectl -n sisense get pods | grep mongo ) 2) You should see ‘>’ sign in the beginning of command line. Type use prismWebDB And hit Enter 3) In order to re-name duplicated columns type the following commands one by one, hit Enter between each of them (in my case there were 3 columns) db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid: "[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_1]"}}); db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid: "[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_2]"}}); db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid: "[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_3]"}}); in which YY is the column number (e.g. 57). 4) After that cube should be available to open in UI2KViews1like0CommentsEdit mode & Share without Publishing changes
When working with Sisense a dashboard owner cannot edit dashboards and revert back to the published dashboard. Could Sisense introduce an edit mode for dashboard owners, where you can possibly discard all changes? Sharing dashboards should be possible without publishing changes. Would be great if that's possible.1.4KViews6likes0CommentsPivot table improvements
I would like to see some improvements regarding the pivot table in Sisense: Measures as rows Right now, when you add multiple measures to the pivot table they are automatically added as an extra column. Every major player in the BI business allows for measures to be added as rows, I would like Sisense to do so as well Expandable dimensions (could be used for almost every widget type) Let's say I have a pivot table showing revenues with categories as rows and years as columns. Ideally, I would like these to be expandable, i.e. if I click on the + icon for years, it should show me the quarters, months and so on. This could also be implemented for line, bar and column charts. For categories e.g. I would like to expand to sub-categories. The drill-down we have right now doesn't work, it zooms in on just 1 category losing an overview of the data.1.6KViews15likes2CommentsFilter by both the dimension and break by on the dashboard
Hi all, Repost of my question in the community forum: Let's say I have a bar chart in my dashboard displaying number of customers over time with customer segments (small, regular, top) in the break by field. When I turn on 'widget affects dashboard filters' I noticed that the dashboard filters are not affected by whatever is in the break by field. I would like an option where I can filter the dashboard by both. From a user perspective it also makes sense. E.g., when a user clicks on the top segment in february 2022 then all other widgets in the dashboard show the values for top customers in february 2022. Kind regards, Kevin879Views5likes1CommentNew filter UI - how do I search and select multiple options?
If I would like to select multiple companies in the new filter UI and I'd have to search for them, the moment I select the first one and start searching for the second one, the first one is dropped. How can I search for multiple companies?Solved2.6KViews0likes2CommentsPivot table showing both grand total and grand average below eachother
For a business dashboard one of the requirements is to show the average and grand total (see attached file). As far as I know, Sisense only allows one of them. Is it possible through e.g. a widget script to include this behavior? Kind regards, ScheurK968Views0likes0CommentsExpand and collapse pivot table
Hi all, Running Sisense L2022.1. I'm getting a lot of requests for expanding and collapsing data within pivot tables. Is this possible? The problem with the drill-down functionality is that it also filters on the value you selected, sometimes I don't want that. Kind regards!Solved3.8KViews0likes2Comments