I have three different sources of data I am trying to merge into a transformer cube: Actual cost information, budget information, and forecast information. The dimension definition to merge this data is Division, Budget code, Job Number. I am able to produce all three of these categories with the actuals query. However, the budget information and forecast inforamtion only have the job number and budeget code available.
I have all of the field names matching so the links can occur. However, whenever I try to create categories I am told I do not have enough links in the data to be able to place it in the dimension properly. So, I made Job Number a unique element of the Dimension. This allows for the category creation to work, but I end up with a bunch of orphans. There are jobs with forecast and budget data that have not accumulated any actuals yet. This is fine to so zero suppressed data in the cube when actuals are the only dimension, but when I try to add the forecast / budget measures, my reporting goes south.
How do I successfully merge these data files to elimate orphans with a Unique definition for a dimension.
Thanks..
I have all of the field names matching so the links can occur. However, whenever I try to create categories I am told I do not have enough links in the data to be able to place it in the dimension properly. So, I made Job Number a unique element of the Dimension. This allows for the category creation to work, but I end up with a bunch of orphans. There are jobs with forecast and budget data that have not accumulated any actuals yet. This is fine to so zero suppressed data in the cube when actuals are the only dimension, but when I try to add the forecast / budget measures, my reporting goes south.
How do I successfully merge these data files to elimate orphans with a Unique definition for a dimension.
Thanks..