mattmca
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Get list of all dashboards/cubes from REST API
Thanks HamzaJ! You're right, I was getting all elasticubes from the API call. Since I was joining the cube data with some dashboard-level stuff, it looked like I didn't have all of them, so I was just confused there. The /dashboards/admin endpoint got me what I needed for dashboards. Thank you!3.1KViews0likes0CommentsGet list of all dashboards/cubes from REST API
I am trying to come up with an automated way to document which of our users and groups have access to which dashboards and cubes. Using the REST API, I was pulling a list of elasticubes using the /v1/elasticubes/getElasticubes endpoint and a list of dashboards using the /v1/dashboards endpoint. However, it looks like this is only pulling the dashboards/cubes for the current user (me). Is there a way to pull a list of ALL dashboards and elasticubes regardless of user from the API, or will I need to do something where I loop through each user to accomplish this?Solved3.1KViews0likes2CommentsPulling Sisense user data into an elasticube
Is there an easy way to pull some of the user data that's stored in Sisense into an elasticube? Specifically what I'm trying to do is pull a table of user IDs and names for all of our users with Sisense accounts and use this data in a dashboard. I can already programmatically do this through the REST API, but I figured there has to be a way to connect to this data directly through a cube. Any idea how I would go about this?Solved2.6KViews0likes2CommentsRe: Max # of columns in source table
Hi KatieG , I ended up getting the cube to build without an error when I ran it later, so I'm not sure what the original issue was. There may have been another load on the server that was competing for RAM when I was first running the build. We are running Sisense on a Windows server. Do you know if there's a similar method for adjusting the reserved/max RAM for the build process on Sisense for Windows? Thanks, Matt3.3KViews0likes1CommentRe: Folder Organization - Moving Dashboards
I had a similar question awhile back, and the short answer is that this isn't available, but there's a workaround. Basically the creator of a folder has to be the dashboard owner in order to move the dashboard into that folder. So you have to pass ownership of each dashboard you want to move to the folder creator, and then they can pass ownership back once they've moved it. There's more details here: https://community.sisense.com/t5/build-analytics/sharing-folder-access-across-dashboard-designers/m-p/2216#M3763.9KViews2likes0CommentsMax # of columns in source table
I am working on importing a flat file (CSV) with a large number of columns (~350) into an elasticube. When I go to build the cube, even when only using a small number of sample rows, I get an error that says "Memory allocation has failed for <column name>. Please verify you have sufficient RAM and try to rebuild." We haven't had any memory issues on the server before, so not sure if this is a hardware limitation or a limitation of a maximum number of allowable columns. Has anybody else run into this issue before?3.3KViews0likes3CommentsRe: Dynamic username on dashboard welcome message
I think your code should work if you add a couple pieces: widget.on('ready', function(){ var eleExists = document.getElementById("myPara"); if(!eleExists){ const para = document.createElement("p"); para.setAttribute("id", "myPara"); const node = document.createTextNode("Welcome " + prism.user.firstName + "!"); para.appendChild(node); const element = document.getElementById("editor-3"); element.appendChild(para); } }) It adds an id to your paragraph element and first checks to make sure that id doesn't exist before adding a new paragraph & text.5.2KViews1like0CommentsRe: Dynamic username on dashboard welcome message
There might be an easier way, but I know one way to accomplish this would be to add a script like this to the widget: widget.on('ready', function(){ document.getElementById("editor-3").innerHTML = "<font size=5>Welcome " + prism.user.firstName + "</font>" }) You would just have to change the "editor-3" to whatever the id is of the div for the text in your text box.5.2KViews1like2Comments