Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Importing Data is not showing up correctly in cube with hierarchical dimensions?
I have a cube with two dimensions: Security and Date. Date has each year with subelements (each month Jan-Dec) and each month has subelements that are the number of days in each. When importing data for say 31Jan10,the value is showing up in each month that has 31 days for all years instead of only on 31Jan10. I have attached a spreadsheet with the paste view shown with the one value in the cube.
Any ideas on how keep the dimension the same but have each date with a unique value? I would prefer not to have three dimensions (year, month, day) or even two (year and month with days as subelements).
Thanks for your help.
RE: Importing Data is not showing up correctly in cube with hierarchical dimensions?
Hi,
if I see it correct your elements are not unique, so days 1-30 will always have the same data no matter what month or year.
To avoid this you could e.g. setup something like this:
2010
-2010-01
-2010-01-01
-2010-01-02
-2010-01-03
....
or for example a sep. dimension for the days. Something like this.
Hope that helps.
Holger
