I know it's in vogue to praise everything that Google puts out ("all hail the mighty Google, bringer of light") but this isn't something that I find useful.
Typically if I'm at Google's main page I have a pretty good idea what I want to...er...google.
If this could end up incorporated into their search results somehow I think it might work a lot better. Show a list of relevant keywords and the number of results those keywords would return. I could really use something like that.
If I search for "foozeball" it would be nice to know that in addition to those results the keyword "foozeball table" has another 835 results (and it might be interesting to know that "foozeball tables" only has 402 results).
I just don't like the idea of this being the defacto search method on the main page (should they every move it into production).
If the boss happens to get one of my emails like that, and can't figure it out, then he's the illiterate one.
Ahh, but when you do let the boss see messages where the grammar is poor or the spelling is incorrect or words are not properly capitalized then it reflects badly on you and it can have an impact on your professional growth in the future.
For example let's assume two equally talented programmers are trying to get one promotion. One has "average" grammar, spelling and capitalization. The other is above average - bordering on excellent - grammar, spelling and capitalization. Who gets the promotion?
It's a small thing, but something like this usually is taken into consideration as a "promotability" factor. When brining someone up through the ranks, I (and my company) want someone who can effectively communicate and interact with others; spelling, grammar, capitalization and punctuation all play a part.
Please enlighten me. I understand relational databases. 'push these buttons and out pops a report in this format is NOT an explanation'.
Okay - I'll take a stab at this. I've been using pivot tables rather heavily since being introduced to them in the last 12 months or so. The step up from a pivot table is a full-blown business intelligence (BI) tool.
Pivot tables allow you to "slice-n-dice" your data. Say you have a set of data that contains the following items: Business unit, sales person, sales territory, customer, customer buying group, order number, item information, cost and revenue. It's all just row after row of data, got it so far?
With SQL or just a big honkin' Excel sheet you can easily calculate data in one dimension (i.e. select/calculate all orders by salesperson X).
It's much more difficult to work in more than on dimension with data in this format. This is where pivot tables are really handy. Say you have the above data, but need to quickly produce a report to show revenue, by customer group, by item, by salesperson, sorted by date. That's more tricky.
This is a bit simplified; with a pivot table you simple select your data "elements" customer group, item and salesperson on the left, your date element on the top and then drop your "revenue" data element (subtract COGS from revenue) in the middle of the pivot and all the fields are automagically calculated. The best part is this all happens from your big, honkin' list of data. You didn't need to figure out any tricky SQL joins, etc when you got the data. You let the pivot table do the work.
Where it gets nice is the "slice-n-dice" capability I mentioned. Say you present this fancy report to your boss who says, "Great! Now show me the same by customer and not customer buying group!" All you have to do is replace the "customer group" element with the "customer" element and all the data is recalculated as fast as you can drop the fields. You didn't have to go back and touch your source data at all, it takes literally seconds to change how you represent the data.
There are a lot of OLAP (online analytical processing) tools out there. We use Cognos' Powerplay tool. It's nothing but a pivot table on steriods. It works on cubes (collections of data) which we produce from our ERP system. Then we can look at and present our data in the OLAP tool extremely easily. We even have executives using this tool (albeit at a less productive level than the hardcore BI geeks).
If you've ever seen someone whiz around with a pivot table or a BI tool you'll understand why I'm rather excited by all of this. It's powerful stuff and makes looking at data, trends in data and "drilling down" into data painless and rather fun. To see it for youself, whip up some bogus data in Excel and run the pivot table wizard (data - PivotTable and PivotChart Report...). It will walk you through your first pivot table in about 2 minutes!
You can't do everything over Remote Desktop that you can with VNC. I've seen this first hand with the admin console for Peoplesoft.
Yep, that's what we use TightVNC for (PeopleSoft). You need console access and as far as I know only VNC and PCAnywhere will give that to you. It beats the heck out of walking to the server room everytime I need to bounce a process scheduler!
I wish terminal services did have a console option because VNC is a little pokey even over 100Mb/s compared to the RDP.
Yeah, I was mistaken when I originally said it came from AP or GL. That was my understanding of the case from the assigned tech in our last general IT meeting.
We've been fortunate so far that this query runs quickly (but doesn't return the correct data). One of the things we have spent a lot of time on is tuning existing queries and building indexes everywhere. It seems like the delivered SQL is either 1) not that tight or 2) needs additional non-delivered indexes to make things snappy.
A friend is a PSFT consultant and at a recient client they created two new indexs and reduced the time AP_MATCHING spent running from 42 hours to about 30 minutes. I haven't seen the hard evidence of that dramatic of a change, but I would believe a large amount of performance could be gained with better indexing.
A 20 union beast in delivered AP or GL? I've been working PeopleSoft for nine years. I do not recall that ever occuring. The delivered printed Check in AP is a bit hairy, with 10 tables or so, but I don't think that is a union.
Seroiusly, tell me where that union is. I'm curious. Post it here.
Ahh - I was wrong - the query isn't in GL or AP, it's in Cost Accounting. The delivered query is CM_PENDING_ACCTG_LINE and it's found in the following navigation: Cost Accounting -> Inventory and Mfg Accounting -> Analyze Inventory Accounting -> Pending Transactions. Setup your search criteria and click the "details" link next to "Accounting Lines not Created" and you'll be greeted with this 20 union query:
SELECT A.BUSINESS_UNIT, A.CM_BOOK, (CONVERT(CHAR(10),A.TRANSACTION_DATE,121)), A.INV_ITEM_ID, A.TRANSACTION_GROUP, A.COST_ELEMENT, A.PRODUCTION_ID, A.CONVERSION_TYPE, A.VARIANCE_TYPE, A.VARIANCE_SOURCE, A.CONFIG_CODE, A.REVALUE_TYPE, A.SEQ_NBR, A.CM_COST_MODE, A.POSTED_FLAG, A.DESCR50, A.REVALUE_FLAG, A.MG_PROC_INSTANCE, (CONVERT(CHAR(10),A.TRANS_DATE,121)), A.TRANS_TIME, A.DT_TIMESTAMP, A.CM_DT_TIMESTAMP_A, A.CM_SEQ_NBR_A, A.CM_SEQ_COST, A.CM_DT_TIMESTAMP, A.CM_SEQ_NBR, A.FROM_PRDN_ID, A.TO_PRDN_ID, A.ORDER_NO, A.ORDER_INT_LINE_NO, A.SCHED_LINE_NBR, A.SHIP_ID, A.CHARGE_TYPE, A.STORAGE_AREA, A.PROCESS_INSTANCE
FROM PS_CM_NP_RECC_VW A
WHERE A.BUSINESS_UNIT =:1
AND A.CM_BOOK =:2
AND ( A.TRANSACTION_DATE <:3
OR A.TRANSACTION_DATE =:3)
UNION
SELECT B.BUSINESS_UNIT, B.CM_BOOK, (CONVERT(CHAR(10),B.TRANSACTION_DATE,121)), B.INV_ITEM_ID, B.TRANSACTION_GROUP, B.COST_ELEMENT, B.PRODUCTION_ID, B.CONVERSION_TYPE, B.VARIANCE_TYPE, B.VARIANCE_SOURCE, B.CONFIG_CODE, B.REVALUE_TYPE, B.SEQ_NBR, B.CM_COST_MODE, B.POSTED_FLAG, B.DESCR50, B.REVALUE_FLAG, B.MG_PROC_INSTANCE, (CONVERT(CHAR(10),B.TRANS_DATE,121)), B.TRANS_TIME, B.DT_TIMESTAMP, B.CM_DT_TIMESTAMP_A, B.CM_SEQ_NBR_A, B.CM_SEQ_COST, B.CM_DT_TIMESTAMP, B.CM_SEQ_NBR, B.FROM_PRDN_ID, B.TO_PRDN_ID, B.ORDER_NO, B.ORDER_INT_LINE_NO, B.SCHED_LINE_NBR, B.SHIP_ID, B.CHARGE_TYPE, B.STORAGE_AREA, B.PROCESS_INSTANCE
FROM PS_CM_NP_DEPC_VW B
WHERE B.BUSINESS_UNIT =:1
AND B.CM_BOOK =:2
AND ( B.TRANSACTION_DATE <:3
OR B.TRANSACTION_DATE =:3)
UNION
SELECT C.BUSINESS_UNIT, C.CM_BOOK, (CONVERT(CHAR(10),C.TRANSACTION_DATE,121)), C.INV_ITEM_ID, C.TRANSACTION_GROUP, C.COST_ELEMENT, C.PRODUCTION_ID, C.CONVERSION_TYPE, C.VARIANCE_TYPE, C.VARIANCE_SOURCE, C.CONFIG_CODE, C.REVALUE_TYPE, C.SEQ_NBR, C.CM_COST_MODE, C.POSTED_FLAG, C.DESCR50, C.REVALUE_FLAG, C.MG_PROC_INSTANCE, (CONVERT(CHAR(10),C.TRANS_DATE,121)), C.TRANS_TIME, C.DT_TIMESTAMP, C.CM_DT_TIMESTAMP_A, C.CM_SEQ_NBR_A, C.CM_SEQ_COST, C.CM_DT_TIMESTAMP, C.CM_SEQ_NBR, C.FROM_PRDN_ID, C.TO_PRDN_ID, C.ORDER_NO, C.ORDER_INT_LINE_NO, C.SCHED_LINE_NBR, C.SHIP_ID, C.CHARGE_TYPE, C.STORAGE_AREA, C.PROCESS_INSTANCE
FROM PS_CM_NP_VARC_VW C
WHERE C.BUSINESS_UNIT =:1
AND C.CM_BOOK =:2
AND ( C.TRANSACTION_DATE <:3
OR C.TRANSACTION_DATE =:3)
UNION
SELECT D.BUSINESS_UNIT, D.CM_BOOK, (CONVERT(CHAR(10),D.TRANSACTION_DATE,121)), D.INV_ITEM_ID, D.TRANSACTION_GROUP, D.COST_ELEMENT, D.PRODUCTION_ID, D.CONVERSION_TYPE, D.VARIANCE_TYPE, D.VARIANCE_SOURCE, D.CONFIG_CODE, D.REVALUE_TYPE, D.SEQ_NBR, D.CM_COST_MODE, D.POSTED_FLAG, D.DESCR50, D.REVALUE_FLAG, D.MG_PROC_INSTANCE, (CONVERT(CHAR(10),D.TRANS_DATE,121)), D.TRANS_TIME, D.DT_TIMESTAMP, D.CM_DT_TIMESTAMP_A, D.CM_SEQ_NBR_A, D.CM_SEQ_COST, D.CM_DT_TIMESTAMP, D.CM_SEQ_NBR, D.FROM_PRDN_ID, D.TO_PRDN_ID, D.ORDER_NO, D.ORDER_INT_LINE_NO, D.SCHED_LINE_NBR, D.SHIP_ID, D.CHARGE_TYPE, D.STORAGE_AREA, D.PROCESS_INSTANCE
FROM PS_CM_NP_TVARC_VW D
WHERE D.BUSINESS_UNIT =:1
AND D.CM_BOOK =:2
AND ( D.TRANSACTION_DATE <
Call me crazy, but if you have a 25-way join, don't you think you have bigger problems than your querying language? Maybe the person that is asking for the join needs to change their business processes.
Go work in a big ERP system. We use PeopleSoft and one of our tech has been debugging an AP (maybe GL?) query that's not working as expected and it's a 20 union beast. That's delivered too, not some home-rolled query. I'm sure there are worse queries out there lurking in the hearts of our system too.
As for just changing our business process, well that's fine in an ideal world, but in practical reality it ain't gonna' happen without an act of Congress. You have to have someone who knows "best-practice" methodolgy come up with a new process, get sign-off across multiple departments and our auditing company so our banks and major vendors are okay with the changes, and then begin process training and roll-out. And that's for a small, private company; if you're public and have to add SOX compliance to the mix...well, good luck.
That's a good thing - but you'd be surprised at how many people are outraged by it (although they are generally the same people who think non-citizens should vote, too, even illegal ones).
I personally agree with the verification, but there is some consternation locally about this (mostly on local talk radio). You can show a utility bill, so it's not like they're forcing people to bring a photo ID. Considering that one of our congrerssional districts has been written up for voter fraud I'm all for an extra verificaion step.
Also explain to me how a picture ID shouldn't be required for first time voters... we are all concerned about voting machine fraud, what about rampant voter fraud?
In Indiana first-time voters in each precinct are required to provide proof of identity before they can vote. We moved a year and a half ago, now both my wife and I have to take proof of ID with us to vote this time around. Driver's license, State ID, utility bill with correct name and address are all acceptible (and maybe a few others). Next general election we will NOT have to show this proof as long as we've not moved.
"...he finally concocted a bizarre scheme wherein the government would tax the bejesus out of XYZ widgets only, thus raising prices and giving newcomers to widget manufacturing a 'fair chance'."
Instead of just giving up at this point, you should have bludgeoned him with a copy of Atlas Shrugged.
Hopefully, you will get one thing out of this rant... Indiana has no freaking money at all!!!!! Yet this lady chose to spend money she didn't have on a useless technolgy program that was probably developed and suppored by foreign workers.
Preach on! I'm also highly put out that Bart Peterson want to add approximately 265,000 square feet to the convention center. Of course there has been no mention of where that money will come from! This is the same mayor of the same city where the police department almost walked off the job when contract negiotiations broke down...over about 2% -- Petersen's mantra through that whole debacle was, "but Indianapolis has no money, not even a single dollar!."
Oh yeah - the city somehow found $24,000,000 in cash and tax breaks to fund a new five star hotel downtown!
For a state that always turns it's electorial votes in for the republican canidate we're surprisingly liberal in Indianapolis...
It's such a friendly sounding word. It sounds like a nickname. 'Hey, Tits, come here. Tits, meet Toots, Toots, Tits, Tits, Toots.' It sounds like a snack doesn't it? Yes, I know, it is, right. But I don't mean the sexist snack, I mean, New Nabisco Tits. The new Cheese Tits, and Corn Tits and Pizza Tits, Sesame Tits Onion Tits, Tater Tits, Yeah. Betcha can't eat just one. That's true I usually switch off . But I mean that word does not belong on the list.
Waitresses really remember the guy who leaves a $2 bill as a tip for a $8 meal
You know who else remembers you? Strippers! Yep, take a wad of $2 bills to the strip club to tip the dancers. You stand out, you're tipping double the regular rate and they come back and flirt with you more often.
ObRealityCheck: Yes I know they only are flirting with me for the money, but sometimes a great pair of tits in your face is payment enough!
The push for PeopleSoft is in their tech called PIA (pure Internet architecture) which relies on either BEA's WebLogic or IBM's WebSphere. BEA also provides the middleware client that PeopleSoft uses (Tuxedo).
Pinching PeopleSoft by buying and restricting BEA's technology would hurt them quite a bit.
What sort of networking groups do you know of in Indy?
Well, there are about a bazillion BNI groups. I was just reciently invited to a new group I've not heard of before (pro flex?), but the invitor said it was pretty much a BNI clone. They are not technical per say, but you usually can turn up great leads. I've never found an insurance salesman or mortgage broker who wasn't in a networking group. Financial planners are good choices to ask too. Ask your group of contacts and I'm willing to bet you'll have access to a whole handful of networking groups -- one of which will be looking for a computer/Internet person.
Indiana is utterly terrible. The Indianapolis Star is terrible.
I disagree. Indiana may not be the mecca of tech jobs, but if you network and are 1) talented and 2) a good "people person" you shouldn't have any troubles. You might not be working for a pure tech-firm, but you could end up being the tech guru in a non-tech firm and have everyone look up to you.
It's amazing how non-technical people fear techies' powers. Get in tight, pull out a few miracles and they'll treat you like royalty...even in Indiana.
And forget the Star. I flip through it occasionally to "see how the market is doing" only to be amazed that there is anything there at all. Get into a local networking group.
Seriously, call up your insurance agent, realtor or mortgage broker and ask about their group. They are ALL in something like BNI or some networking group, and there is usually a spot for a computer person. You just have to be flexible. Bill yourself as a networking or ecommerce guru and start networking. You'll get noticed, some jobs and if you spin it right, a job offer (if you don't want to work for yourself).
If nothing else, this site brings back fond memories of sitting in a small, dark room rolling back the B deck to hit the right cue point for the A/B roll (I didn't have access to frame accurate or RS422 controlled decks back then).
My highschool got one of these back in 1992 or 1993 and I managed to convice them to give me THREE class periods of independent study time to shoot, write and edit our weekly "TV" show. It was a blast and it really taught me how to work under a deadline -- I was the only student doing the show and fourth period EVERY FRIDAY there had to be 15 minutes of show in the can ready to show.
At the time, it was somewhat of a jewel on our school's crown to have a weekly, entirely student-produced show. We just thought it was more fun that trig.
The last time I poked my head in my high school, they had several classes dedicated to broadcast and communications with a real teacher assigned to it and everything. They were also doing a daily show in lieu of the morning announcements over the PA system.
I feel proud I got to do it my way and learn something in the process. God bless the Toaster -- and who coudln't resist tossing in a few Kiki effects or falling sheep here and there!;-)
If the local record store is dying, where will I go to pickup a bong, some incense and maybe a creepy black-light poster?
Think of the thousands of pot-heads out there who will have no place to buy questionable detox supplements, no place to buy artistic "tobacco" paraphernalia... Where will I get gallons and gallons of patchouli oil?
As for how this would affect the relative value of IT professionals. I can't help but think that RFID making all physical objects in the supply-chain trackable by computers is going to be a huge boon to IT jobs.
I agree 110%
Geeks, get out there and get yourself familiar with supply-chain systems and ERP systems (PeopleSoft, SAP, Oracle, etc.) that include supply chain features. I look around my own home town with almost no hiring happening in the tech sector except for enterprise type positions. I've been working closely with an ERP implementation consulting company and they can't seem to find qualified people fast enough.
Funny how when a WalMart STOPS a passing along of a price increase to a customer we get mad and when the RIAA/MPAA CONTINUES to pass along a price increase to a customer we still get mad.
Sometimes a price increase isn't a big, evil thing. Market fluctuation and all that jazz drive the price of raw materials. Sometimes it justs costs more to make the things we all way and in those times the only way to cut prices is to trim fat or find a cheaper way to make the product...
Almost all of the fat is trimmed. Sure, there is always some fat to trim, but there is damn little anymore. Find a cheaper way to make the product? Done. It's called third-world labor and it's almost all that's left in the textile industry.
Do you know that the average hourly wage of a textile worker in the US is about $10.50? Do you know that the average hourly wage of a textile worker in Turkey is about $0.18? China? twenty-four cents an hour!
Yeah, we found a way to make it cheaper and now all the work is done somewhere else. Say all you want about globalization, but I would just as soon have found a way to keep those jobs in America.
Bingo! I've not heard of a monopsony before, but this is a perfect description of the position that a lot of companies are in with WalMart.
Sorry I can post and mod the same article, or I would prop this up so others could see it.
The problem is that in many cases WalMart is buying from both Company A and Company B. They tell the industry not to raise prices and if one company folds they just go and find Company C and the cycle repeats.
Interesting points. I will admit that while I don't feel my paycheck is to high, someone making less might see it differently. I also don't know anyone who gets their check and thinks, "You know, I make sooo much money, maybe I should ask for a pay cut..." But I digress.
I've seen the margins on some of the products we do sell to WalMart and it's in the single digits in most cases. It's not a question of if our competitors are more efficient, it's a question of raw costs. WalMart is putting so much pressure on the industry at the top, and the mill are putting so much pressure at the bottom that there is rapidly becoming no room for us.
At some point WalMart may just become the world's largest direct importer for themselves and stop dealing with companies like us directly. If so, well maybe it's not a bad thing. A previous poster had it right though, once your supply chain is setup to accomodate the additional burden of WalMart you can't just walk away. It will cost jobs and cost productivity losses to re-tool the supply chain to adjust.
There is no reason that ANY company deserves business any more than any other company. It's all about the almighty dollar and as long as companies cowtow to pressures like this WalMart will continue to push money and jobs out of our economy. I shouldn't hope you would feel sorry for me, I don't feel sorry for you. That's business...
I also understand that MY business to to keep myself as valueable as I can. I am interested in this from a "how can this hurt me" standpoint, and so should everyone in I.T. who might be crushed in WalMart's wheels of commerce. When it comes down to the bottom line, if we get squeezed out (or step out under pricing pressure) they will come find someone like your client. They already are, their appitite for stock is voracious -- locust-like if you will -- and if we're all not aware of thir practices it will be you in the position of watching what they do very carefully as they put the squeeze on you!
Slashdot Mirror
Typically if I'm at Google's main page I have a pretty good idea what I want to...er...google.
If this could end up incorporated into their search results somehow I think it might work a lot better. Show a list of relevant keywords and the number of results those keywords would return. I could really use something like that.
If I search for "foozeball" it would be nice to know that in addition to those results the keyword "foozeball table" has another 835 results (and it might be interesting to know that "foozeball tables" only has 402 results).
I just don't like the idea of this being the defacto search method on the main page (should they every move it into production).
In Korea, voice recognition is only for old people
- If the boss happens to get one of my emails like that, and can't figure it out, then he's the illiterate one.
Ahh, but when you do let the boss see messages where the grammar is poor or the spelling is incorrect or words are not properly capitalized then it reflects badly on you and it can have an impact on your professional growth in the future.For example let's assume two equally talented programmers are trying to get one promotion. One has "average" grammar, spelling and capitalization. The other is above average - bordering on excellent - grammar, spelling and capitalization. Who gets the promotion? It's a small thing, but something like this usually is taken into consideration as a "promotability" factor. When brining someone up through the ranks, I (and my company) want someone who can effectively communicate and interact with others; spelling, grammar, capitalization and punctuation all play a part.
Okay - I'll take a stab at this. I've been using pivot tables rather heavily since being introduced to them in the last 12 months or so. The step up from a pivot table is a full-blown business intelligence (BI) tool.
Pivot tables allow you to "slice-n-dice" your data. Say you have a set of data that contains the following items: Business unit, sales person, sales territory, customer, customer buying group, order number, item information, cost and revenue. It's all just row after row of data, got it so far?
With SQL or just a big honkin' Excel sheet you can easily calculate data in one dimension (i.e. select/calculate all orders by salesperson X).
It's much more difficult to work in more than on dimension with data in this format. This is where pivot tables are really handy. Say you have the above data, but need to quickly produce a report to show revenue, by customer group, by item, by salesperson, sorted by date. That's more tricky.
This is a bit simplified; with a pivot table you simple select your data "elements" customer group, item and salesperson on the left, your date element on the top and then drop your "revenue" data element (subtract COGS from revenue) in the middle of the pivot and all the fields are automagically calculated. The best part is this all happens from your big, honkin' list of data. You didn't need to figure out any tricky SQL joins, etc when you got the data. You let the pivot table do the work.
Where it gets nice is the "slice-n-dice" capability I mentioned. Say you present this fancy report to your boss who says, "Great! Now show me the same by customer and not customer buying group!" All you have to do is replace the "customer group" element with the "customer" element and all the data is recalculated as fast as you can drop the fields. You didn't have to go back and touch your source data at all, it takes literally seconds to change how you represent the data.
There are a lot of OLAP (online analytical processing) tools out there. We use Cognos' Powerplay tool. It's nothing but a pivot table on steriods. It works on cubes (collections of data) which we produce from our ERP system. Then we can look at and present our data in the OLAP tool extremely easily. We even have executives using this tool (albeit at a less productive level than the hardcore BI geeks).
If you've ever seen someone whiz around with a pivot table or a BI tool you'll understand why I'm rather excited by all of this. It's powerful stuff and makes looking at data, trends in data and "drilling down" into data painless and rather fun. To see it for youself, whip up some bogus data in Excel and run the pivot table wizard (data - PivotTable and PivotChart Report...). It will walk you through your first pivot table in about 2 minutes!
- You can't do everything over Remote Desktop that you can with VNC. I've seen this first hand with the admin console for Peoplesoft.
Yep, that's what we use TightVNC for (PeopleSoft). You need console access and as far as I know only VNC and PCAnywhere will give that to you. It beats the heck out of walking to the server room everytime I need to bounce a process scheduler!I wish terminal services did have a console option because VNC is a little pokey even over 100Mb/s compared to the RDP.
We've been fortunate so far that this query runs quickly (but doesn't return the correct data). One of the things we have spent a lot of time on is tuning existing queries and building indexes everywhere. It seems like the delivered SQL is either 1) not that tight or 2) needs additional non-delivered indexes to make things snappy.
A friend is a PSFT consultant and at a recient client they created two new indexs and reduced the time AP_MATCHING spent running from 42 hours to about 30 minutes. I haven't seen the hard evidence of that dramatic of a change, but I would believe a large amount of performance could be gained with better indexing.
Seroiusly, tell me where that union is. I'm curious. Post it here.
Ahh - I was wrong - the query isn't in GL or AP, it's in Cost Accounting. The delivered query is CM_PENDING_ACCTG_LINE and it's found in the following navigation: Cost Accounting -> Inventory and Mfg Accounting -> Analyze Inventory Accounting -> Pending Transactions. Setup your search criteria and click the "details" link next to "Accounting Lines not Created" and you'll be greeted with this 20 union query:
SELECT A.BUSINESS_UNIT, A.CM_BOOK, (CONVERT(CHAR(10),A.TRANSACTION_DATE,121)), A.INV_ITEM_ID, A.TRANSACTION_GROUP, A.COST_ELEMENT, A.PRODUCTION_ID, A.CONVERSION_TYPE, A.VARIANCE_TYPE, A.VARIANCE_SOURCE, A.CONFIG_CODE, A.REVALUE_TYPE, A.SEQ_NBR, A.CM_COST_MODE, A.POSTED_FLAG, A.DESCR50, A.REVALUE_FLAG, A.MG_PROC_INSTANCE, (CONVERT(CHAR(10),A.TRANS_DATE,121)), A.TRANS_TIME, A.DT_TIMESTAMP, A.CM_DT_TIMESTAMP_A, A.CM_SEQ_NBR_A, A.CM_SEQ_COST, A.CM_DT_TIMESTAMP, A.CM_SEQ_NBR, A.FROM_PRDN_ID, A.TO_PRDN_ID, A.ORDER_NO, A.ORDER_INT_LINE_NO, A.SCHED_LINE_NBR, A.SHIP_ID, A.CHARGE_TYPE, A.STORAGE_AREA, A.PROCESS_INSTANCE FROM PS_CM_NP_RECC_VW A WHERE A.BUSINESS_UNIT = :1
AND A.CM_BOOK = :2
AND ( A.TRANSACTION_DATE < :3
OR A.TRANSACTION_DATE = :3) :1
AND B.CM_BOOK = :2
AND ( B.TRANSACTION_DATE < :3
OR B.TRANSACTION_DATE = :3) :1
AND C.CM_BOOK = :2
AND ( C.TRANSACTION_DATE < :3
OR C.TRANSACTION_DATE = :3) :1
AND D.CM_BOOK = :2
AND ( D.TRANSACTION_DATE <
UNION
SELECT B.BUSINESS_UNIT, B.CM_BOOK, (CONVERT(CHAR(10),B.TRANSACTION_DATE,121)), B.INV_ITEM_ID, B.TRANSACTION_GROUP, B.COST_ELEMENT, B.PRODUCTION_ID, B.CONVERSION_TYPE, B.VARIANCE_TYPE, B.VARIANCE_SOURCE, B.CONFIG_CODE, B.REVALUE_TYPE, B.SEQ_NBR, B.CM_COST_MODE, B.POSTED_FLAG, B.DESCR50, B.REVALUE_FLAG, B.MG_PROC_INSTANCE, (CONVERT(CHAR(10),B.TRANS_DATE,121)), B.TRANS_TIME, B.DT_TIMESTAMP, B.CM_DT_TIMESTAMP_A, B.CM_SEQ_NBR_A, B.CM_SEQ_COST, B.CM_DT_TIMESTAMP, B.CM_SEQ_NBR, B.FROM_PRDN_ID, B.TO_PRDN_ID, B.ORDER_NO, B.ORDER_INT_LINE_NO, B.SCHED_LINE_NBR, B.SHIP_ID, B.CHARGE_TYPE, B.STORAGE_AREA, B.PROCESS_INSTANCE FROM PS_CM_NP_DEPC_VW B WHERE B.BUSINESS_UNIT =
UNION
SELECT C.BUSINESS_UNIT, C.CM_BOOK, (CONVERT(CHAR(10),C.TRANSACTION_DATE,121)), C.INV_ITEM_ID, C.TRANSACTION_GROUP, C.COST_ELEMENT, C.PRODUCTION_ID, C.CONVERSION_TYPE, C.VARIANCE_TYPE, C.VARIANCE_SOURCE, C.CONFIG_CODE, C.REVALUE_TYPE, C.SEQ_NBR, C.CM_COST_MODE, C.POSTED_FLAG, C.DESCR50, C.REVALUE_FLAG, C.MG_PROC_INSTANCE, (CONVERT(CHAR(10),C.TRANS_DATE,121)), C.TRANS_TIME, C.DT_TIMESTAMP, C.CM_DT_TIMESTAMP_A, C.CM_SEQ_NBR_A, C.CM_SEQ_COST, C.CM_DT_TIMESTAMP, C.CM_SEQ_NBR, C.FROM_PRDN_ID, C.TO_PRDN_ID, C.ORDER_NO, C.ORDER_INT_LINE_NO, C.SCHED_LINE_NBR, C.SHIP_ID, C.CHARGE_TYPE, C.STORAGE_AREA, C.PROCESS_INSTANCE FROM PS_CM_NP_VARC_VW C WHERE C.BUSINESS_UNIT =
UNION
SELECT D.BUSINESS_UNIT, D.CM_BOOK, (CONVERT(CHAR(10),D.TRANSACTION_DATE,121)), D.INV_ITEM_ID, D.TRANSACTION_GROUP, D.COST_ELEMENT, D.PRODUCTION_ID, D.CONVERSION_TYPE, D.VARIANCE_TYPE, D.VARIANCE_SOURCE, D.CONFIG_CODE, D.REVALUE_TYPE, D.SEQ_NBR, D.CM_COST_MODE, D.POSTED_FLAG, D.DESCR50, D.REVALUE_FLAG, D.MG_PROC_INSTANCE, (CONVERT(CHAR(10),D.TRANS_DATE,121)), D.TRANS_TIME, D.DT_TIMESTAMP, D.CM_DT_TIMESTAMP_A, D.CM_SEQ_NBR_A, D.CM_SEQ_COST, D.CM_DT_TIMESTAMP, D.CM_SEQ_NBR, D.FROM_PRDN_ID, D.TO_PRDN_ID, D.ORDER_NO, D.ORDER_INT_LINE_NO, D.SCHED_LINE_NBR, D.SHIP_ID, D.CHARGE_TYPE, D.STORAGE_AREA, D.PROCESS_INSTANCE FROM PS_CM_NP_TVARC_VW D WHERE D.BUSINESS_UNIT =
- Call me crazy, but if you have a 25-way join, don't you think you have bigger problems than your querying language? Maybe the person that is asking for the join needs to change their business processes.
Go work in a big ERP system. We use PeopleSoft and one of our tech has been debugging an AP (maybe GL?) query that's not working as expected and it's a 20 union beast. That's delivered too, not some home-rolled query. I'm sure there are worse queries out there lurking in the hearts of our system too.As for just changing our business process, well that's fine in an ideal world, but in practical reality it ain't gonna' happen without an act of Congress. You have to have someone who knows "best-practice" methodolgy come up with a new process, get sign-off across multiple departments and our auditing company so our banks and major vendors are okay with the changes, and then begin process training and roll-out. And that's for a small, private company; if you're public and have to add SOX compliance to the mix...well, good luck.
I personally agree with the verification, but there is some consternation locally about this (mostly on local talk radio). You can show a utility bill, so it's not like they're forcing people to bring a photo ID. Considering that one of our congrerssional districts has been written up for voter fraud I'm all for an extra verificaion step.
In Indiana first-time voters in each precinct are required to provide proof of identity before they can vote. We moved a year and a half ago, now both my wife and I have to take proof of ID with us to vote this time around. Driver's license, State ID, utility bill with correct name and address are all acceptible (and maybe a few others). Next general election we will NOT have to show this proof as long as we've not moved.
Instead of just giving up at this point, you should have bludgeoned him with a copy of Atlas Shrugged.
Preach on! I'm also highly put out that Bart Peterson want to add approximately 265,000 square feet to the convention center. Of course there has been no mention of where that money will come from! This is the same mayor of the same city where the police department almost walked off the job when contract negiotiations broke down...over about 2% -- Petersen's mantra through that whole debacle was, "but Indianapolis has no money, not even a single dollar!."
Oh yeah - the city somehow found $24,000,000 in cash and tax breaks to fund a new five star hotel downtown!
For a state that always turns it's electorial votes in for the republican canidate we're surprisingly liberal in Indianapolis...
(sarcasm) Go Kernan & Petersen (sarcasm off!)
- For an interesting look at Walmart's pricing, look around on the web for the article on the 1 gallon jar of pickles from Vlassic.
Here's the article about the pickles. It's rather long, but completely interesting to read.- And Tits doesn't even belong on the list!!
It's such a friendly sounding word. It sounds like a nickname. 'Hey, Tits, come here. Tits, meet Toots, Toots, Tits, Tits, Toots.' It sounds like a snack doesn't it? Yes, I know, it is, right. But I don't mean the sexist snack, I mean, New Nabisco Tits. The new Cheese Tits, and Corn Tits and Pizza Tits, Sesame Tits Onion Tits, Tater Tits, Yeah. Betcha can't eat just one. That's true I usually switch off . But I mean that word does not belong on the list.- Waitresses really remember the guy who leaves a $2 bill as a tip for a $8 meal
You know who else remembers you? Strippers! Yep, take a wad of $2 bills to the strip club to tip the dancers. You stand out, you're tipping double the regular rate and they come back and flirt with you more often.ObRealityCheck: Yes I know they only are flirting with me for the money, but sometimes a great pair of tits in your face is payment enough!
The push for PeopleSoft is in their tech called PIA (pure Internet architecture) which relies on either BEA's WebLogic or IBM's WebSphere. BEA also provides the middleware client that PeopleSoft uses (Tuxedo). Pinching PeopleSoft by buying and restricting BEA's technology would hurt them quite a bit.
- What sort of networking groups do you know of in Indy?
Well, there are about a bazillion BNI groups. I was just reciently invited to a new group I've not heard of before (pro flex?), but the invitor said it was pretty much a BNI clone. They are not technical per say, but you usually can turn up great leads. I've never found an insurance salesman or mortgage broker who wasn't in a networking group. Financial planners are good choices to ask too. Ask your group of contacts and I'm willing to bet you'll have access to a whole handful of networking groups -- one of which will be looking for a computer/Internet person.- Indiana is utterly terrible. The Indianapolis Star is terrible.
I disagree. Indiana may not be the mecca of tech jobs, but if you network and are 1) talented and 2) a good "people person" you shouldn't have any troubles. You might not be working for a pure tech-firm, but you could end up being the tech guru in a non-tech firm and have everyone look up to you.It's amazing how non-technical people fear techies' powers. Get in tight, pull out a few miracles and they'll treat you like royalty...even in Indiana.
And forget the Star. I flip through it occasionally to "see how the market is doing" only to be amazed that there is anything there at all. Get into a local networking group.
Seriously, call up your insurance agent, realtor or mortgage broker and ask about their group. They are ALL in something like BNI or some networking group, and there is usually a spot for a computer person. You just have to be flexible. Bill yourself as a networking or ecommerce guru and start networking. You'll get noticed, some jobs and if you spin it right, a job offer (if you don't want to work for yourself).
My highschool got one of these back in 1992 or 1993 and I managed to convice them to give me THREE class periods of independent study time to shoot, write and edit our weekly "TV" show. It was a blast and it really taught me how to work under a deadline -- I was the only student doing the show and fourth period EVERY FRIDAY there had to be 15 minutes of show in the can ready to show.
At the time, it was somewhat of a jewel on our school's crown to have a weekly, entirely student-produced show. We just thought it was more fun that trig.
The last time I poked my head in my high school, they had several classes dedicated to broadcast and communications with a real teacher assigned to it and everything. They were also doing a daily show in lieu of the morning announcements over the PA system.
I feel proud I got to do it my way and learn something in the process. God bless the Toaster -- and who coudln't resist tossing in a few Kiki effects or falling sheep here and there! ;-)
Good times...
Think of the thousands of pot-heads out there who will have no place to buy questionable detox supplements, no place to buy artistic "tobacco" paraphernalia... Where will I get gallons and gallons of patchouli oil?
We must not let the local record stores die!
- "...will benefit from the digirally-distributed analog MPP network..."
Ahh, digiral, must be some new Japanese technology! What will they think of next?I agree 110%
Geeks, get out there and get yourself familiar with supply-chain systems and ERP systems (PeopleSoft, SAP, Oracle, etc.) that include supply chain features. I look around my own home town with almost no hiring happening in the tech sector except for enterprise type positions. I've been working closely with an ERP implementation consulting company and they can't seem to find qualified people fast enough.
- Funny how when a WalMart STOPS a passing along of a price increase to a customer we get mad and when the RIAA/MPAA CONTINUES to pass along a price increase to a customer we still get mad.
Sometimes a price increase isn't a big, evil thing. Market fluctuation and all that jazz drive the price of raw materials. Sometimes it justs costs more to make the things we all way and in those times the only way to cut prices is to trim fat or find a cheaper way to make the product...Almost all of the fat is trimmed. Sure, there is always some fat to trim, but there is damn little anymore. Find a cheaper way to make the product? Done. It's called third-world labor and it's almost all that's left in the textile industry.
Do you know that the average hourly wage of a textile worker in the US is about $10.50? Do you know that the average hourly wage of a textile worker in Turkey is about $0.18? China? twenty-four cents an hour!
Yeah, we found a way to make it cheaper and now all the work is done somewhere else. Say all you want about globalization, but I would just as soon have found a way to keep those jobs in America.
- It's not a monopoly, it's a monopsony.
Bingo! I've not heard of a monopsony before, but this is a perfect description of the position that a lot of companies are in with WalMart.Sorry I can post and mod the same article, or I would prop this up so others could see it.
The problem is that in many cases WalMart is buying from both Company A and Company B. They tell the industry not to raise prices and if one company folds they just go and find Company C and the cycle repeats.
I've seen the margins on some of the products we do sell to WalMart and it's in the single digits in most cases. It's not a question of if our competitors are more efficient, it's a question of raw costs. WalMart is putting so much pressure on the industry at the top, and the mill are putting so much pressure at the bottom that there is rapidly becoming no room for us.
At some point WalMart may just become the world's largest direct importer for themselves and stop dealing with companies like us directly. If so, well maybe it's not a bad thing. A previous poster had it right though, once your supply chain is setup to accomodate the additional burden of WalMart you can't just walk away. It will cost jobs and cost productivity losses to re-tool the supply chain to adjust.
There is no reason that ANY company deserves business any more than any other company. It's all about the almighty dollar and as long as companies cowtow to pressures like this WalMart will continue to push money and jobs out of our economy. I shouldn't hope you would feel sorry for me, I don't feel sorry for you. That's business...
I also understand that MY business to to keep myself as valueable as I can. I am interested in this from a "how can this hurt me" standpoint, and so should everyone in I.T. who might be crushed in WalMart's wheels of commerce. When it comes down to the bottom line, if we get squeezed out (or step out under pricing pressure) they will come find someone like your client. They already are, their appitite for stock is voracious -- locust-like if you will -- and if we're all not aware of thir practices it will be you in the position of watching what they do very carefully as they put the squeeze on you!