Hello,
Is it possible to set the scope for a query subject in a relational model in FM?
Hi Ammus,
Scope is in between Relational Dimension and Measure Dimension in DMR (Multi Dimensional Model). If u won't provide also automatically it takes. But In Relational Model there is no scope we have to give Relationship between Dimensions and Facts it would be cardinality 1..1/1..n/0..1/0..n.
Thanks Satheesh for your reply.
I have a relational package in which some facts are not related to some of the dimensions. But if I drag these unrelated facts and dimensions it gives wrong data (a cross join). Is there any way we can avoid this?
Hi,
If there is Relationship means obviously it will cross join.
May I know the need why you are taking unrelated Facts and dimensions...???
Hey Ammus1234,
First of all, that sounds like a VERY wrong way to model data. Like Satheesh said, a package should contain related objects. At the very least, unrelated query subjects should be separated ib the same package to different namespaces to hint that they are unrelated. If the objects aren't related, it seems strange to put them together in a manner which might confuse users or developers.
If you have no choice - for the life of me I can't think of a scenario, but let's assume there is one - you can set a governor in FM to prohibit cross-joins. This way, when a user drags in unrelated objects, instead of wrong data they will get an error message. But the better solution would be to model the data properly.
Thanks for your reply Satheesh and Nimrod. I think the actual user requirement is not possible for the moment.