How to use Specified columns in Cube Views

[STDN]

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.

[Cosimo]

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]

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.

[Michel_Sabourin]

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.