Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Anybody please explain me with example,
What is SecondaryDimensionality() and Dimensionality()
- Thanks in Advance
Villyee
Hi
Dimensionality() and SecondaryDimensionality() can be used to determine in which type of line in a chart (Total / subtotal / detail) the expression is evaluated.
Please find attached
Take care in a pivot table, the outcome of Dimensionality / secondary dimensionality() is depending on your dimensions pivoted to the top or not, just play around it
HTH
sushil
Hi Villyee,
Primary Dimension - Is Main Dimension in chart(It's Work Expression Lable (Show In X or Y - Axis))
Secondary Dimension Splited Base On Primary Dimension Woking Like Lable...
Here Attach One Qvw It's Very Helpful For u
Regards By
ArjunKrish
customer is a dimension and sum(Amount) as Measures
Amount is slicing based on the customer
if u have 3 dimension eg
customer ,product, Somtthng else not realated to cutomer but related the vendor
now if u use the function dimensionality(customer) mean it will show only customer only these two dimension will slice the measure
Based on only customer and product dimension u r getting the measure