Search results for query: *

How can you tell if the report cache is being used when you run a report in the Web interface? I have executed several reports in Desktop, and when I re-execute the reports in Desktop, the reports come back instantaneously. When I run the same reports in the Web interface, it seems that the...

I have two Attributes Parent and Child (Parent has many Children) I have a metric called COST which is defined as max(Cost) at the Child level I have another metric called visits which is a count of records the a Child has in the visits table. Lastly I have a compound metric called REV which is...

Mufasa, Man, you are remarkable, thanks so much! cheese

I have a string with pipes as in the following that I need to extract multiple pieces of data from. 12345|1600 Pennsylvania|09999|01876|2125559999 it contains an id, address, second id, zipcode and lastly telephone number but sometimes the value is like this '|||01876|2125559999' and i...

Thanks again Dagon! I hope to someday reciprocate. cheese

How many connections to MSTR Web can be open for a given user at the same time? Thanks in advance, cheese

hello all, can you help me create the correct substring or intstring statement to return everything after the second to last underscore of a column value? for example: column value = 'cheesy_man_5000' return value should be 'man_5000' column value = 'tek_tips_is_the_best' return value should...

Thanks so much Dagon, that did the trick! cheesy

hello all, can you help me create the correct substring or intstring statement to return everything after the last underscore of a column value? for example: column value = 'cheesy_man_5000' return value should be '5000' column value = 'tek_tips_is_the_best' return value should be 'best' I...