Recent content by cohibaman

I need to update records in a table where there exists 2+ occurrences of a record. What would be the best approach? Thanks

I believe you're right in that the manual "cut n paste" process will perhaps be the best approach. Thanks for you help! Have a great July 4th weekend.

Is there another way to merge two or more "identical" excel spreadsheets other than the "cut n paste" method?

Thanks Geoff for the speedy reply.The spreadsheets contain "similar" not "identical" formats of data lists.

I need to merge several Excel spreadsheets, all of similar format into a single spreadsheet. What is the best/recommednded practice to accomplish the merge? Thanks

It worked!!!! The resolution was a combination of all of ya'lls suggestions and comments. One main problem was the "UND Group Code" attribute id was not defined correctly, hence the reason for the "NulltoZero" and "ApplySimple" condition not producing the desired...

Thanks MLIM and others for ya'lls help. I'm going thru the "fast track" learning curve with Microstrategy. I'll gather the info and post.

I've tried the "ApplySimple" function, but it was to no avail. As suggested, below is an example of the extracted data generated by the sql: table:ZZSP00 UND_GROUP_CD PRD_LN_ID WJXBFS1 USPP 1304 57727 USPT 1310 536...

I've check the Microstrategy Knowledge base and did review tech note TN4000-7X0-0323, as well as others. However my problem does not involve lookup tables. Thanks

I have a problem running a report in MicroStrategy version 7.2.1. The problem occurs when two separate tables are linked on common elements(ie. tblx_fld1, tblx_fld2 and tbly_fld1, tbly_fld2.)and the elements contains null values. When the match elements contains a null value, I cannot pull any...

Sorry, the form was closed when I was testing the report function. It now works. Thanks again for your help and time.

Based upon the previous recommendations, I created a form that contains a value(date). In turn, I created a text box on the report and set the control source of a text box to reference the form's value as in "=IIf([HasData]=True,"",Forms![frmdate]![end])". When I run the...

My "last" question(I hope)on this issue. Could I accomplish the same result if I place a text box on the actual report itself and if so then what would syntax be? Thanks

It worked. Thanks for your help!

I'll give it a try. Thanks again for all your help!