generated query in repor

[Mita]

Hi All,

I have done union of two fact tables in report studio.but when i generate the query its not doing the union and the data is also coming for one fact table not both..
M i missing anything?

[saumil287]

That's strange,
but first try in FM to union 2 queries, also check the total number of rows in new generated query.


Thanks

[BigChris]

Do your columns match up between the two queries? Also, bear in mind that the field names will be taken from the first query in the union, so it might be difficult to know which query they're coming from. One way round that is to add an identifier column in each of the two queries so that you can see which one the data is coming from in the union.

[MFGF]

Hi All,

I have done union of two fact tables in report studio.but when i generate the query its not doing the union and the data is also coming for one fact table not both..
M i missing anything?

As a sanity check, can you list the steps you took? Are you sure you are basing your report on the items from the query resulting from the union, and not from one of the underlying queries?

MF.

[Mita]

yes , its showing the union but again its doing a full outer join. :(

[MFGF]

yes , its showing the union but again its doing a full outer join. :(

It sounds to me like you are getting a stitch query? Are you familiar with modelling your data in Framework Manager? If so, you need to look carefully at your model to determine which relationships are causing this query split and fix your model accordingly. If you're not a modeller, you should go and discuss this with the person who built your model.

Cheers!

MF.

[Mita]

Thank you for the suggestion..:)