Search results for query: *

i have one table with two columns (market SKU column and item SKU column) which have the same identical data, the only differentiating factor being Indicator which tells which one is a markte SKU and which one is a Item SKU. The applysimple statement might work, let me give it a try. Thanks for...

These are two different columns on the same table that have the same contents. i was thinking of defining the market sku as ApplySimple("Case when #0 = 'Y' then #1 end", IND_COL, SKU_MKT) but don't think it will work. Any other ideas would greatly be appreciated.

WE have table which has two SKU's, one is a product SKU and the other is market SKU. now both these SKU columns are exactly same, the only differentiating factor between these is an indicator column which is set to 'Y' for the market SKU. now i need to make an attribute where i choose the...

WE have table which has two SKU's, one is a product SKU and the other is market SKU. now both these SKU columns are exactly same, the only differentiating factor between these is an indicator column which is set to 'Y' for the market SKU. now i need to make an attribute where i choose the...

hi again nlim you can contact me at unique_seller@yahoo.com. thanks su

hi nlim i was wondering if you were interested in doing some off site consulting. the pay is pretty good. Please let me know if you are interested and we can go ahead from there. the work would be pretty similar to the cross join problem that you handled. su

Thanks for all your help.

hi nlim i did that and updated the schema. here is what i have now I am posting the sql generated from three simple reports. The first report would contain just the first metric and just one attribute from 1 frequently used dimension. The second report would contain the same attribute but...

hi nlim stupid question but can you refresh my memory on how to add MOB_SAMEDAY_DATA as a source table in ID form. thanks su

hi nlim mob_same_day is not included as a source table in the attribute. i will add and see if it runs. thanks for your help. will keep you updated su

hi nlim here is sql that might better explain my situation. the cross join is between the tables LU_TM_DAY and MOB_SAMEDAY_DATA I am posting the sql generated from three simple reports. The first report would contain just the first metric and just one attribute from 1 frequently used...

I am posting the sql generated from three simple reports. The first report would contain just the first metric and an attribute from two unrelated but frequently used dimensions (like customer type and Store State). The second report would contain the same two attributes but with the second...

hi i have a probelm with two conditonal metrics(both have a time filter at report level). they work fine when i run them both alone(the data comes back good) but when i run them along with any of the other metrics,they screw up the other metrics also and duplicates the metric columns(some of...