Datacube - Join the Conversation! https://forums.datanyx.com/community/datacube/ Datanyx Support Forum en-US Thu, 21 May 2026 15:45:49 +0000 wpForo 60 I need to add security tags to the columns in a data set. How do I achieve this? https://forums.datanyx.com/community/datacube/i-need-to-add-security-tags-to-the-columns-in-a-data-set-how-do-i-achieve-this/ Mon, 26 Dec 2022 10:26:22 +0000 Step 1: Select the Data source from the dropdown.  
Step 2: Double click on the dataset. The 'Edit Columns' popup appears. (Refer to the image below). 

Step 3: Select user defined column type and security tags from the respective dropdowns.  

Step 4: Click on save. The saved security tags will be added to those dataset columns. (Refer to the image below).  

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-need-to-add-security-tags-to-the-columns-in-a-data-set-how-do-i-achieve-this/ I need to delete an existing data cube. How do I do this? https://forums.datanyx.com/community/datacube/i-need-to-delete-an-existing-data-cube-how-do-i-do-this/ Mon, 26 Dec 2022 10:23:53 +0000 Step 1: Create a data cube or open an existing data cube. Click on the plus icon at the bottom right of the screen. Project list appears. 
Step 2: Click on the Data cube delete icon in a project list. (Refer to the image below).  
Step 3: User will get a warning message. Click on the ok button. (Refer to the image below).  
Step 4: Click ok in the delete popup. The Data cube is deleted from the project list. (Refer to the image below).  
]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-need-to-delete-an-existing-data-cube-how-do-i-do-this/ The existing data cube needs to be edited. How do I do this? https://forums.datanyx.com/community/datacube/the-existing-data-cube-needs-to-be-edited-how-do-i-do-this/ Mon, 26 Dec 2022 10:20:50 +0000 Step 1: Create a data cube or open an existing data cube. Click on the plus icon at the bottom right of the screen. Project list appears. 
Step 2: Click on the 'Edit' icon for any existing Data cube in a project list. (Refer to the image below).

Step 3: Drag and drop the datasets to the main screen and make a connection between the datasets. 

Step 4: Click on 'Result'. 

Step 5: Click on the 'Settings' icon. 

Step 6: Configure Data cube popup will appear. In that popup select column names and display names according to the user requirement. 

Step 7: Click on 'Save'.          

Step 8: To see the 'Results', click on 'Show Preview'. 

Step 9: Click on the save icon. The existing Data cube will be updated with the new changes. 

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/the-existing-data-cube-needs-to-be-edited-how-do-i-do-this/ I need to share the data cube that has been created with different users. How do I do this? https://forums.datanyx.com/community/datacube/how-do-i-share-a-data-cube-that-has-been-created-to-different-users/ Mon, 26 Dec 2022 10:18:45 +0000 Step 1: Create a data cube or open an existing data cube. Click on the plus icon at the bottom right of the screen. Project list appears.  
Step 2: Click on the 'Data cube' share icon from the project list. (Refer to the image below).  

Step 3: The user will get a pop-up message. Select the user and select the role. 

Step 4: Click on the share button. (Refer to the image below). 

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/how-do-i-share-a-data-cube-that-has-been-created-to-different-users/ I need to set multiple filters in a data set. How do I add filters in a data cube? https://forums.datanyx.com/community/datacube/i-need-to-set-multiple-filters-in-a-data-set-how-do-i-add-filters-in-a-data-cube/ Mon, 26 Dec 2022 09:53:41 +0000 Step 1: Click on line and click on the settings icon. (Refer to the image below).

Step 2: Select 'Filter' from the popup. 

Step 3: Click on filter and click on the settings icon. (Refer to the image below).  

Step 4: In configure filter popup, select Logical operator, Columns, Filter operator, Values, Actions. 

Step 5: Click on the 'Save' button. (Refer to the image below).  

Step 6: Click on results and click on the settings icon. 

Step 7: In configure popup, select column name and display name according to the user requirement. 

Step 8: Click on 'Save'. 

Step 9: Click on 'Show Preview'.  

Step 10: In results, the filtered data will appear. (Refer to the image below).  

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-need-to-set-multiple-filters-in-a-data-set-how-do-i-add-filters-in-a-data-cube/ I need to aggregate the result in the data cube. How do I achieve this? https://forums.datanyx.com/community/datacube/i-need-to-aggregate-the-result-in-the-data-cube-how-do-i-achieve-this/ Mon, 26 Dec 2022 09:49:20 +0000 Step 1: Click on line and click on the settings icon. (Refer to the image below).

Step 2: Select 'Aggregate' operation from the popup. Then aggregate is added in between the 'sheet' and 'result'. (Refer to the image below).  
Step 3: Click on aggregate and click on the settings icon. Configure aggregate popup will appear. Select the column names and aggregate positions from the dropdown. Click on save. (Refer to the image below).  

Step 4: Click on results and click on the settings icon. 

Step 5: In the configure popup, select the column name and the display name according to the user requirement. 

Step 6: Click on 'Save'. 

Step 7: Click on 'Show Preview'.  

Step 8: In Results, aggregate data will appear. (Refer to the image below).  

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-need-to-aggregate-the-result-in-the-data-cube-how-do-i-achieve-this/ The data cube that I have created is now inner joined. How do I change the join type to right join? https://forums.datanyx.com/community/datacube/the-data-cube-that-i-have-created-is-now-inner-joined-how-do-i-change-the-join-type-to-right-join/ Mon, 26 Dec 2022 09:42:45 +0000 Step 1: Click on the line and click on the settings icon. (Refer to the image below).  

Step 2: Select the Join operation in the popup. 

Step 3: Drag and drop another dataset onto the main screen. 

Step 4: Join dataset sheets with join operation. (Refer to the image below).  

Step 5: Click on Join and click on the settings icon. 

Step 6: A pop-up appears. The user is able to select 'Right join' in join type dropdown. Make the connection between the two tables. 

Step 7: Click on save button. (Refer to the image below).  

Step 8: Click on results and click on the settings icon. 

Step 9: In configure popup, select column name and display name according to the user requirement. 

Step 10: Click on 'Save'. 

Step 11: Click on 'Show Preview'.  

Step 12: In Results, the total data which is in the right table will be shown and from left table only common data will appear. (Refer to the image below).  

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/the-data-cube-that-i-have-created-is-now-inner-joined-how-do-i-change-the-join-type-to-right-join/ I have selected the join operator. How do I initiate left join operation? https://forums.datanyx.com/community/datacube/i-have-selected-the-join-operator-how-do-i-initiate-left-join-operation/ Mon, 26 Dec 2022 09:36:58 +0000 Step 1: Click on the line and click on the settings icon. (Refer to the image below).  

Step 2: Select the 'Join' operation in the popup. 

Step 3: Drag and drop another dataset onto the main screen. 

Step 4: Join dataset sheets with join operation. (Refer to the image below).  

Step 5: Click on 'Join' and click on the settings icon. 

Step 6: A pop-up appears. The user can select 'Left join' from the join type dropdown and make the connection between two tables. 

Step 7: Click on the save button. (Refer to the image below).  

Step 8: Click on results and click on the settings icon. 

Step 9: In the configure popup select column name and display name according to the user requirement. 

Step 10: Click on 'Save'. 

Step 11: Click on 'Show Preview'.  

Step 12: In Results, the total data which is in the left table will be shown and from the right table only common data will appear. (Refer to the image below).  

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-have-selected-the-join-operator-how-do-i-initiate-left-join-operation/ I need to view the common data between the two data sets that have been joined. How do I do this? https://forums.datanyx.com/community/datacube/i-need-to-view-the-common-data-between-the-two-data-sets-that-have-been-joined-how-do-i-do-this/ Mon, 26 Dec 2022 09:32:07 +0000 Step 1: Click on the line and click on the settings icon. (Refer to the image below).  

Step 2: Select the Join operation in the popup. 

Step 3: Drag and drop another dataset onto the main screen. 

Step 4: Join dataset sheets with join operation. (Refer to the image below).  

Step 5: Click on Join and click on the settings icon.  

Step 6: A pop-up appears. The user can select the inner join option from the join type dropdown and make the connection between two tables. 

Step 7: Click on the save button. (Refer to the image below).

Step 8: Click on 'Results' and click on the settings icon. 

Step 9: In the configure popup, select column name and display name according to the user requirement. 

Step 10: Click on 'Save'. (Refer to the image below).  

Step 11: Click on 'Show Preview'.  

Step 12: The common data between these two tables will be shown in the 'Results'. (Refer to the image below).  

]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-need-to-view-the-common-data-between-the-two-data-sets-that-have-been-joined-how-do-i-do-this/ I need to include another dataset in the data cube that has been created. How do I bring the other dataset to the current data cube? https://forums.datanyx.com/community/datacube/i-need-to-include-another-dataset-in-the-data-cube-that-has-been-created-how-do-i-bring-the-other-dataset-to-the-current-data-cube/ Mon, 12 Dec 2022 11:10:49 +0000 Step 1: Click on the line and click on the settings icon. (Refer to the image below).  

Step 2: Select the Join operation in the popup. 

Step 3: Drag and drop another dataset onto the main screen. 

Step 4: Join dataset sheets with join operation. (Refer to the image below).  

Step 5: Click on Join and click on the settings icon. (Refer to the image below).

Step 6: In the configure join popup, select the join type and make a connection between the left table and right table. 

Step 7: In join type, the user will be given three options to choose from. 

  • Inner join. 
  • Left join. 
  • Right join. (Refer to the images below). 
]]> Datacube Nikhila https://forums.datanyx.com/community/datacube/i-need-to-include-another-dataset-in-the-data-cube-that-has-been-created-how-do-i-bring-the-other-dataset-to-the-current-data-cube/