Join problem in FM

Post Reply
tm1fmuser
Posts: 1
Joined: Mon Jul 18, 2016 5:44 pm
OLAP Product: Transfomer
Version: 7.3
Excel Version: 2013

Join problem in FM

Post by tm1fmuser »

Hi,

Anyone caould help me with a possible loop join issue ?

Thanks in advance to anyone willing to at leats advice something,
Attachments
IsThisaLoop.png
IsThisaLoop.png (19.96 KiB) Viewed 56145 times
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Join problem in FM

Post by BariAbdul »

Hi tm1fmuser,Although name may sound bit similar this is not Cognos Forum rather it is Cognos TM1 Forum.

Please post your query in Cognoise forum under Framework Manager section:

http://www.cognoise.com/
https://www.ibm.com/developerworks/comm ... ags=cognos

http://businessintelligence.ittoolbox.c ... ognos10-l/ Thanks
"You Never Fail Until You Stop Trying......"
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Join problem in FM

Post by jim wood »

Bari,

It is a TM1 forum but we have sections for the likes of BI as TM1 interfaces with it. You'll also notice that we have forums for other products like Essbase. While your advise to post on other forums is sound, I wouldn't go driving people away just because of the title. If we wanted to do that then we'd close this section of the site down.

Fmuser,

It may take a while for you to get a reply here as the posting rate isn't that great, so I would also post this on the sites provided by Bari,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: Join problem in FM

Post by sachin »

tm1fmuser wrote:Hi,

Anyone caould help me with a possible loop join issue ?

Thanks in advance to anyone willing to at leats advice something,
Yes, alias shortcut is a way to address the join traps you see in the FM model. In the (g)olden days of Impromptu, we had the ability to define join weights and that was one way you could force the engine to generate the SQL path you'd want. It went way when Cognos ReportNet came on along with FM. We had put in a ENH request to bring that feature back into FM. It has been several years I last worked on FM. A lot might have changed, I am not sure if the join weights is introduced or not.

You can find dozens of links in Cognoise or IT Toolbox regarding this problem.
Check out my blog for some good information on TM1, SPSS
st2000
Posts: 62
Joined: Mon Aug 15, 2016 8:48 am
OLAP Product: TM1 (Windows) & SSAS 2014 Ent.
Version: 10.2.0 FP3
Excel Version: Excel 2013
Location: Hamburg, DE, EU
Contact:

Re: Join problem in FM

Post by st2000 »

I learning always to avoid modelling relations from Dim to Dim or Fact to Fact, but only let Dims touch Facts and vice versa. You could try to make first a join on all these Dim-tables to get a resultset ready to connect to the Facttable. Wrap this into an entity and join it to the Fact: Dim-Entity 1 .. N Fact. Some more similar stuff could be learned here: http://www.ibm.com/developerworks/data/ ... ge605.html

Note that FM is not a DBMS-Engine, but a tool to model entities under the special FM rules. Cognos generates from this queries in Cognos SQL which afterwards translates to the genuine SQL used by the DBMS. Check out here also: https://books.google.de/books?id=vQwYHs ... r.&f=false
-----------------------------------
Best regards,
Stefan
Post Reply