Forum Discussion

STDN's avatar
STDN
New Contributor III
3 years ago

How to use Specified columns in Cube Views

Hi All, I need to share few specified columns  from one Cube View to another, Can anyone suggest how to use specified  columns in Cube Views.     Thanks in Advance.
Cube View
Cosimo's avatar
Cosimo
Contributor II
3 years ago

Hi New Member,

I rarely use Share Specified rows/columns but here goes.

1) In the cube view General Settings / Sharing section, Select Specified Columns for Column Sharing property.

2) In the Rows and Columns slider, select and existing column (or create a new column)

3) Select the Sharing tab, set "Share Settings From Another CubeView" to True

4) Select a "Cube View Name for Sharing"

5) Specify the column that from other cube view that you'd like to use.

 

That's pretty much it. You do have to manually specify what columns to use from a separate cube view which is a little tedious but it works as expected. 

 

 

 

  • STDN's avatar
    STDN
    New Contributor III
    2 years ago

    Hi  Cosimo,

     

    Thanks for your reply, I have one more question , is it possible to share multiple Cube Views columns to  One specific Cube View?

     

     

    Thanks.

     
    • Mike_Sabourin's avatar
      Mike_Sabourin
      Contributor II
      2 years ago

      unfortunately, you can only share one set of columns per share. You would need to set up another cube view using the specific columns to share plus the other columns you want and then use that to share.