Framework manager - determinants

[Sep2013]

Hi MFGF, Blom , I really apologise, as i believe that i am guilty of marking blom's post.
Due to some stress , I did not notice i reacted bad!
My apologies, as I know you are spending time to helpus,unconditionally.
:)
Thanks a lot.
By reading information, and Blom's reference help, i could see that i dont need to use determinants as Fact 1 is linked to tables 1,2,3,4,5,6,7 where fact 2 is linked to only 1,2,3,4.
Thus I can use actual values from detail fact and "target and mtd" values from summary fact. :):):)
Thanks a lot for your help :):):)

[MFGF]

Hi MFGF, Blom , I really apologise, as i believe that i am guilty of marking blom's post.
Due to some stress , I did not notice i reacted bad!
My apologies, as I know you are spending time to helpus,unconditionally.
:)
Thanks a lot.
By reading information, and Blom's reference help, i could see that i dont need to use determinants as Fact 1 is linked to tables 1,2,3,4,5,6,7 where fact 2 is linked to only 1,2,3,4.
Thus I can use actual values from detail fact and "target and mtd" values from summary fact. :):):)
Thanks a lot for your help :):):)

No worries. I'm glad everything worked out ok :)

[Sep2013]

Hi Gurus,
I really appreciate your seupportI have started developing my model...
I am stuck at a point as follows:


1)Plan hierarchy  has following members
plan definition key
plandefinition ID
Plan Name
Product Group
Product Class
Product Sub Class
Market
2) Plan group has following members :
Plan grouping key
product class
product group
product subclass
Market
The second table doesnt include "Plan name and is create from first table using the following query:
Select distinct product group, product class,product subclass, product market from dbo.planhierarchy.

3)Meaning Target data exists only at 4 levels and actual data exists at "plan name" level.

4) Is it possible to have only one query subject that contains (Plan definition Key) amd ( Plan Grouping Key) and all 5 other attributes but ability of FM to keep in mind that ACtual should be at 5 levels and targets at 4 levels?

5)I thought its kind of conformed dimensions needing determinants logic.

6)But i dont know how do i combine these two dimension tables into one....