Hi,
My Cube has data for around 8 years but the only fiscal year for Monthly comparison is 08. We want to partition the cube.
How we can make the partition? I do not want to do monthly partition. (Technically I know how to make partition, DB Perofrmance-->Partitioning and set 0FISCVARNT as constant if partition is on 0FISCPER based)
Can anyone has any suggestions?
Thanks