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 » Mon Jul 18, 2016 6:16 pm

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 8960 times

BariAbdul
Regular Participant
Posts: 403
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: Join problem in FM

Post by BariAbdul » Wed Jul 20, 2016 9:11 am

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: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Join problem in FM

Post by jim wood » Wed Jul 20, 2016 11:55 am

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

User avatar
sachin
Posts: 90
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 » Tue Aug 02, 2016 12:53 am

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: 56
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 » Mon Aug 15, 2016 2:32 pm

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