Hi community, 

I have an client who want to have 1 colum more for 1 attribut on the tableau 

I can do it with dynamique report or custom report but i wondering if i can do it with a Exploration view.

Any help or idea will be appreciated!!!

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------

#PlanningAnalyticswithWatson

Hi Duong,
The cube viewer is not supporting the attribute dispaly yet.
You could create a hierarchy if this is a text attribute or display alias.

------------------------------
Svetlana Pestsova
IBM Planning Analytics Product Manager
------------------------------

Original Message:
Sent: Fri October 21, 2022 02:46 AM
From: Duong DAU
Subject: Attribut on Exploration View

Hi community, 

I have an client who want to have 1 colum more for 1 attribut on the tableau 

I can do it with dynamique report or custom report but i wondering if i can do it with a Exploration view.

Any help or idea will be appreciated!!!

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------

#PlanningAnalyticswithWatson

Hey Duong,

This can be achieved through cube view MDX.  If you click on MDX and paste the below in at the top of the MDX code

With Member [YourColumDim].[YourColumnDim].[Replace this with what you want it called on your report] AS [YourRowDim].[YourRowDim].Currentmember.Properties("YourRowAttribute")

The editor can be a little frustrating so you may find it easier to do in Notepad or Notepad ++ etc first.  It should add at the end of the report, I believe you'll be able to re-order in the subset editor from there.

Rgds

James

------------------------------
James McCarthy
------------------------------

Original Message:
Sent: Fri October 21, 2022 02:46 AM
From: Duong DAU
Subject: Attribut on Exploration View

Hi community, 

I have an client who want to have 1 colum more for 1 attribut on the tableau 

I can do it with dynamique report or custom report but i wondering if i can do it with a Exploration view.

Any help or idea will be appreciated!!!

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------
#PlanningAnalyticswithWatson

Thank a lot James, it work perfectly !!!
I have another question, can i make dynamic that attribut choice? 
for exemple: i can chose another attribut and it change automatique MDX? 
Thank a lot !

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------

Original Message:
Sent: Fri October 21, 2022 09:53 AM
From: James McCarthy
Subject: Attribut on Exploration View

Hey Duong,

This can be achieved through cube view MDX.  If you click on MDX and paste the below in at the top of the MDX code

With Member [YourColumDim].[YourColumnDim].[Replace this with what you want it called on your report] AS [YourRowDim].[YourRowDim].Currentmember.Properties("YourRowAttribute")

The editor can be a little frustrating so you may find it easier to do in Notepad or Notepad ++ etc first.  It should add at the end of the report, I believe you'll be able to re-order in the subset editor from there.

Rgds

James

------------------------------
James McCarthy

Original Message:
Sent: Fri October 21, 2022 02:46 AM
From: Duong DAU
Subject: Attribut on Exploration View

Hi community, 

I have an client who want to have 1 colum more for 1 attribut on the tableau 

I can do it with dynamique report or custom report but i wondering if i can do it with a Exploration view.

Any help or idea will be appreciated!!!

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------
#PlanningAnalyticswithWatson

You can have the attribute change from one to another if that's what you mean?

Just use a combination of the above and the picklist filter I described previously.

------------------------------
James McCarthy
------------------------------

Original Message:
Sent: Sat October 22, 2022 06:18 PM
From: Duong DAU
Subject: Attribut on Exploration View

Thank a lot James, it work perfectly !!!
I have another question, can i make dynamic that attribut choice? 
for exemple: i can chose another attribut and it change automatique MDX? 
Thank a lot !

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne

Original Message:
Sent: Fri October 21, 2022 09:53 AM
From: James McCarthy
Subject: Attribut on Exploration View

Hey Duong,

This can be achieved through cube view MDX.  If you click on MDX and paste the below in at the top of the MDX code

With Member [YourColumDim].[YourColumnDim].[Replace this with what you want it called on your report] AS [YourRowDim].[YourRowDim].Currentmember.Properties("YourRowAttribute")

The editor can be a little frustrating so you may find it easier to do in Notepad or Notepad ++ etc first.  It should add at the end of the report, I believe you'll be able to re-order in the subset editor from there.

Rgds

James

------------------------------
James McCarthy

Original Message:
Sent: Fri October 21, 2022 02:46 AM
From: Duong DAU
Subject: Attribut on Exploration View

Hi community, 

I have an client who want to have 1 colum more for 1 attribut on the tableau 

I can do it with dynamique report or custom report but i wondering if i can do it with a Exploration view.

Any help or idea will be appreciated!!!

------------------------------
Duong DAU
Consultant EPM Finance Transformation & Performance - Micropole


M +33 (0)7 62 61 85 33
F +33 (0) 4 26 99 60 81
131 Boulevard Stalingrad / 69100 Villeurbanne
------------------------------
#PlanningAnalyticswithWatson