My question is View related.
One Accounts has two transactions . I want to show two line in views.
Example :
Views Showing :
---------------
Dimension Dimension Dimension MeasuresDim
---------------- -------------- ---------- --------------
Account1 - Category1 - Royalty_1 - $100
- Royalty_2 - $ 300
Expecting Views :
----------------------
Dimension Dimension Dimension MeasuresDim
Account1 Category1 Royalty_1 $100
Account1 Category1 Royalty_2 $ 300
Can any body help me please ?
Views Display
-
jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Views Display
If you slice it to excel it will look as you have suggested.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
Rayan12
- Posts: 18
- Joined: Sat Mar 16, 2013 12:07 am
- OLAP Product: Cognos EX
- Version: 9.1.1
- Excel Version: 2010
Re: Views Display
Jim
Thanks . But i am using Cube View .
Any other solution ?
Thanks . But i am using Cube View .
Any other solution ?
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Views Display
Nope. That's just how the cube viewer works.Rayan12 wrote:Any other solution ?