Mixing package and report datasources

[Michael75]

Hi All,
Environment is C10.1.1 and Oracle. It's my first post, so pls excuse any clumsiness, and I don't have huge experience with Transformer.

For my two or three previous cubes I used only package datasources. But requirements for the measures datasource in the current cube are much more complex. I started with package only, but changed to the following setup:
1. wrote a report to produce the measures columns, containing specific join logic etc.
2. copied the generated SQL, and used it to made a new datasource Query Subject in my FM logical layer
3. re-published the package
4. remapped my cube datasource to this new QS

I realise now that I've created something which is complex and hard to maintain. If it is OK to mix package and report datasources in a cube, I only have to maintain my report (1), and the other steps become unnecessary.

Does anyone have experience of this?

TIA for you help
Michael

[Lynn]

I don't see any reason why you couldn't do that. Each data source is a separate entity so you should be able to mix as many different types of data sources as your heart desires.

[Michael75]

Thanks, Lynn.

In fact, I guess I was just a bit wary about using report datasources (as mentioned in OP I previously used only package datasources) because a couple of years ago, I think it was on 8.4, report datasources were seriously unreliable here (they failed to run ~4 times out of 5), and IBM's response to my ticket was to either switch to package datasources, or migrate to 8.4.1.

Rgds, Michael