Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hey guys,
I want to create a list of all the columns of my pivot table. How can I do that?
Thanks.
Max
 
					
				
		
 marcus_sommer
		
			marcus_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		The dimensions could you get with something like:
GetObjectField(0, 'CH01') & '|' & GetObjectField(1, 'CH01') ...
but for the expressions is nothing available - unless you could use macros (it wont be easy to develop such kind of stuff).
- Marcus
 
					
				
		
 arvind_patil
		
			arvind_patil
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Maximilion,
With the help of inline table like below:
DummyDim:
Load * Inline [
_DummyDm
YTD
QTD
MTD
Today
];
Thanks,
Arvind Patil
 balabhaskarqlik
		
			balabhaskarqlik
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 balabhaskarqlik
		
			balabhaskarqlik
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		In Script, in last tab, create a table with all the Required Dimensions to use in the UI area.
By that you can filter the Dimensions, those are going to use by different objects.
