is there a problem using iqd with only 1 column (measure)??

[drseuss]

I have to use an iqd with only two columns, a measure and an id. This is because the measure column comes from a different database. How do I deal with this? How does the allocation work for all the dimensions?

Thanks.

 

[sln007]

Dr.,
You can use 2 data sources in the Model.
1. The data source with the ID. This will be the only Dimension and Category.
2. The data source with the Measure AND the corresponding ID. The ID is required so that the measure relates to the Dimension/Categpry. Simply drag the Measure field into the "MEASURES" window. (*NOTE* The ID in both data sources must be identically named)
That will give you a simple Cube......1 Dimension, 1 Measure.
I hope this works for you.