How to add two dimensions by column without displaying row totalss
CHANG GENG
Active Partner
Hello!
I have a cube with 2 dimensions : day, product.
(relationship: day(N)-> month(1), product(N)->plant(1))
for example, I want to populate plant and month by column in my data view.
Usually, if I populate 2 dimensions by column, there will be an error. -> "an error occurred" as picture 1.
I could get a result only if I check the row totals as picture 2.
Unfortunately, my customers do not want to see the row totals value,
Is there way for us to add two dimensions by column without displaying row totals?
------------------------------
chang geng
consultant
NTT DATA GLOBAL SOLUTIONS CORPORATION
Japan
------------------------------
I have a cube with 2 dimensions : day, product.
(relationship: day(N)-> month(1), product(N)->plant(1))
for example, I want to populate plant and month by column in my data view.
Usually, if I populate 2 dimensions by column, there will be an error. -> "an error occurred" as picture 1.
I could get a result only if I check the row totals as picture 2.
Unfortunately, my customers do not want to see the row totals value,
Is there way for us to add two dimensions by column without displaying row totals?
------------------------------
chang geng
consultant
NTT DATA GLOBAL SOLUTIONS CORPORATION
Japan
------------------------------
Tagged:
0
Answers
-
Hi @chang geng,
think it is a bug. Maybe you write a ticket to support. In a previous Version of BOARD (non Web) it was possible.
------------------------------
Dietmar Jeschkeit
Senior BI Consultant
Braincourt GmbH Gesellschaft für Managementberatung & Informationssysteme
Germany
------------------------------
-------------------------------------------0