Fiscal year variant Problem
I am showing Fiscal year/period as a drilldown in my Query . The Fiscal year/period is held as a simple year in the cube (eg 008/2009). However I have two records with different different Fiscal year variant for the same Fiscal year/period it is being displayed as two different records . In other words there has to be one single record instead of two even though the Fiscal year variant is differnt . Anybody know how i can do this?
points will be awarded..