Recent content by zxzzzzzz

My actual report with ranking works fine--all I want to do here is add the rank number/count to the report too. Thanks for your help nlim and fukudahs. As to mstrNate, I am so tired of getting smart answers to posts on this board--I'm so sorry that I'm not an expert like you must be. It gets...

I looked @ the PDF, and it really only shows me how to do ranking but not how to put the rank count/number on the report. I have an example where there is an actual metric called "Rank by Store" that shows me the rank # (ex: #5 out of top 100). I can't recreate that. Thanks!

I have been shown this once but have already forgot since I don't do ranking reports very often. How do you make the report show the actual rank number (1,2,3...)?? Thanks!

Has anyone been told to be careful having more than one person (Administrator) with the ability to update the schema since there can be conflicts if more than one person updates at the same time? We are rolling our first project out to our powerusers this week, and right now nobody but the...

I'm needing to do LPAD on a couple of elements as they are not all the desired length of 4. zero padding--not space. LPAD(class_number,4,'0')

Is it possible in MSTR to do cell padding on an attribute? Example: LPAD(xxxxx,4,'0') My database is Oracle 9i.

We are thinking about participating in this beta, and though I've recently been attending classes I've never heard of this beta--only Guttenberg. ??? Thanks!

Thanks! Of my attributes called style_id1, style_id2, style_id3, style_id4, style_id5, and style_id6 only one of them may have the value of '352' that I'm looking for OR none of them will have this value. In the CASE statement using all six conditions, will it look at all six needing to have...

I have six single attributes which I want to throw into a separate attribute. My SQL statement is something like: IF attrib1='T' OR attrib2='T' OR attrib3='T' OR attrib4='T' OR attrib5='T' OR attrib6='T' THEN 'T' ELSE 'F'. I'm not sure how to approach this one. Suggestions??? Thanks!

Thank you VERY MUCH!!! It was the last thing I would have thought to look at, and my connection user ID was wrong. THANKS A MILLION!! [bigsmile]

I have a brand new project that uses a valid database connection. The warehouse catalog has only one view in it. My report continuously gives me "Report returned no data" ; however, when I run the SQL generated by MSTR in SQL+, it works fine. Am I missing some stupid little...

Great. We too are using Windows NT authentication to 7.2.3, but I don't have our "purchased license" CD key to upgrade the demo software to full version software. We are only in the implementation planning stages of MSTR, and I have only had Admin and Rptg Essentials classes so far...

Out of curiousity,,,, does Windows authentication also apply to web users?? ((i still have the demo product until the end of September when we are installing 7.2.3))

Thanks a million nlim! You are great!! [medal]

How do I do this?? Is it is I-server config?? This is new to me. Thanks!