TM1 Forum

jimicron wrote: However, as you are aware, Microsoft doesn't have a 64-bit "Microsoft Text Driver." In another post of mine, we went off topic about this very issue but I wanted to create a new topic specifically for this.

lotsaram wrote:

jimicron wrote: However, as you are aware, Microsoft doesn't have a 64-bit "Microsoft Text Driver." In another post of mine, we went off topic about this very issue but I wanted to create a new topic specifically for this.

Well actually Microsoft do have a 64bit text driver. It is included with 64bit Access and also available "stand alone" as part of the 64bit Access DB Engine. The problem however is that Microsoft doesn't support side by side instal of both 32 and 64 bit drivers. If there are any 32 bit Office components installed on the machine at all then the 64 bit drivers will not install. This rules this out for any TM1 server with Excel installed, which is probably the majority of installs.

However, what it's doing is still brining in ALL MPN's but then only populating the attributes of the MPN's that have "MCP" as vProductFamily. Whereas, in a SQL statement, it wouldn't include the MPN's that don't have "MCP" as Product Family. The hope is to see the same behavior where I would only get the MPN's that have "MCP" as vProductFamily and not all the rest.

jimicron wrote: Right now, with that statement above, it's pulling in all records and then just populating the ones where Product Family is "MCP" - I don't want the records if the Product Family isn't MCP.

If(vProductFamily@<>'MCP');
ItemSkip;
EndIf;

jimicron wrote: Thanks a lot! Makes my day!

I was curious though and so I kept it on the "Metadata" tab but got rid of it on the "Data" tab and it appears it did the same thing. I looked at the attributes and they were populated. OR, am I missing something where I am maybe getting lucky? It's not hard to put it in both tabs... and it's doing exactly what I want.. but was just curious.

• TIs process the whole data source for the data tab and metadata tab separately, so an Item Skipped (by the ItemSkip function) on one tab will still appear on the other (unless skipped on that tab also.)
• The ItemSkip function needs to occur BEFORE any other functions, it essentially hits the ItemSkip and interprets it as the end of the tab for that data record.
• If an ItemSkip is encountered at the top of a tab, the data record is transacted at an incredibly quick pace - almost as if it was never there.

jimicron wrote:No, we have been putting it BEFORE the autogenerated all along. The issue was that I only had it on the "Data" tab and it was NOT on the "Metadata" tab. But, by putting it in both places, it's working just as expected.

Maybe part of David's inside joke was the whole @<> thing... which is just a different thought process than my humble brain... so, out of curiosity again, I tried this on both "Data" and "Metadata" tabs:

Code: Select all

If(vProductFamily@='MCP');
EndIf;

But, that didn't work. I was thinking... okay... let's call an ace and ace... so in my statement... just say what I want and that is when "Product Family" = 'MCP' ... but it's like it needs something else... something to replace the "itemskip" like "iteminclude" (or something like that). SOmething that says, hey, if it = this... then give it to me.

At least I am out of my bind. I am just trying to learn further and understand b/c it will help me so much more in building these models and teaching others. Appreciate the help as always!

If(vProductFamily@='MCP');

Rest of Code


EndIf;

jimicron wrote:So, you are saying do this?

Code: Select all

If(vProductFamily@='MCP');
If(vProductFamily@<>'MCP');
ItemSkip;
EndIf;

Seems easier to just say this:

Code: Select all

If(vProductFamily@<>'MCP');
ItemSkip;
EndIf;

I am not seeing anything that is the opposite of "ItemSkip' ... b/c my thought was to do something like this:

Code: Select all

If(vProductFamily@='MCP');
ItemInclude;
EndIf;

I know that "ItemInclude" doesn't exist.. but that is what I was hoping... or wondering... if there was something equivalent to it. Not a biggie if not. Again, I am over my hurdle, I was just trying to learn more and understand Thanks again!!

If ( vVariable @<> 'Turnip' );
      ItemSkip;
EndIf;

CellPutN ( Value, sCub, v1, v2, v3, 'Measure');

If ( vVariable @= 'Turnip' );
     CellPutN ( Value, sCub, v1, v2, v3, 'Measure');
EndIf;