Temp tables in Project Green

[Dukester0122]

David,

Are there plans of replacing the temp tables with sql tables?

It's very frustrating as you can't replicate the temp tables because the field isn't available.

Look at some of the later threads where administrators try to duplicate reports like Historical Stock Status and they can't seem to find the right tables because most of them were temp.

Just my 2 cents.

Regards,
Duke

 

[bradth]

If you run a trace, you can then see what stored procedure is called to create these temp tables. You can then get the names of the tables from the stored proc, there commented out at the beginning of the procedure. A query could then be created to replicate the results. Its a pain I know, but its possible.

Brad

 

[Dukester0122]

I've done these a couple of times but you can't do it for all modules. Like us we're using manufacturing, I've checked all the stored procedures when the Mftg Receipt and Outsource was ran but took me half-day to just figure out that it wasn't going to work. So it's easier said than done!

 

[bradth]

That's true, I've run into a few problems where I've spent countless hours trying to figure out what field comes from what table, only to find out its not possible. But then again its always the things that seem so simple that are the hardest and take the longest, Murphy's Law.

Brad

 

[Dukester0122]

You should see the mftg tables. Unlike Distribution and Financial tables where there's logic (10000-work/open,30000-history,40000-setup), mftg tables especially the ones from ICONTROL don't seem to have logic to it.

I'll take this from one of the users here...AND THAT'S WHY THEY CALL IT GREAT PAINS!!!

 

[bradth]

I am also familar with the MFG module and hear your pain, trying to figure out all of the tables and the consistency of them all...

Brad

 

[winthropdc]

Guys

I know some tricks for using VBA with reports which use temporary tables, but sometimes they are needed.... either to overcome limitations of the report writer or just because the data is not available in the form needed in the source tables.

As for Project Green, I have no idea what is planned there, but you won't be using the Dexterity report writer, so you should not have the same limitations.

Hope this helps.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[Dukester0122]

From conversations with MBS during Convergence this year, they might go with Reporting Services and have pre-defined cubes.