Recent content by kpescatore

Other users can use the same cache but then need to have the same secuirty filters as well as other criteria. In the admin guide there is a section on report caching that explains when a cache will be used and when it wont.

Under the menu Graph --> Grids and Scales… select "Y1 Axis" tab on the left then select the "Scales" tab across the top. Uncheck "Always include Zero in the Scale". The graph will auto select numbers based on the data. This is also where you can hard code values for the min and max. If your...

You won’t need to outer join the metrics because there is no final pass of SQL. The final join is handled in an analytic pass by the IServer. Depending on the filters you use a null result may not be displayed. So if there are no values returned for a specific group that group will not be...

This is probably not what you are looking for but I have the same problem. From what I can tell there is no way to pass the filter criteria from a conditional metric to a template. The only way around it is to use custom groups with vanilla metrics. The filter criteria from the Custom Group...

Why is a metric ok to create but not and attib? Are you just trying to get the date on the report when they print it? If this is the case then they can add it is to the header or footer when they click the print icon then select "Edit Custom Settings". Here they will be allowed to add the...

you can also set the invisible porperty at the metric level by right clicking on the metric and checking "Hidden" From the desktop you will need to check "Display hidden objects" under the menu Tools-->Desktop Preferences Then on the Desktop tab select the Browsing Options... button. The...

I agree with asudevil. If you don't like the formats that they give you for date go to the custom setting and type in the format you want. The only thing I can't get is the "st" from "1st". The format I used in the custom was just "mmm dd yyyy". If you need the "st","nd","rd","th" you will...

Hi, All you need to do is drag the attribute into to the Group by section. You will need to pull the attribute from the report that is set as the Primary Dataset. If the group by section is not at the top above the doc then you need to go to the View menu and select groupings and the...

Is there a way to remove the word "Metric" from a report? I can do it easily for the actual metrics or attibute headers but "Metric" I just can't get rid of. So on a report you have: Metric | M1 | M2 A1 | A2 I would like to just remove the actual word so it looks like Thanks...

This probably isn't the best solution but it looks like it works but I haven't tested it for very many dates. Either way it should put you in the right direction. ApplySimple("datepart(dd,#0)/7 +1", [givendate])

you will probably need to create 2 attributes but this is dependant on your schema. The first attribute will be the ID attribute. It will only have an ID form. No Description is necessary. I am assuming that this is a key for the table. You may not need this. The second is the UserName...

It sounds like your ID is not unique in the table. If that is the case then you either need to create a lookup table for username giving it a unique ID. Then put that new ID on the other table. A second solution is to create the ID as its own attrib and create the username as its own atrrib...

Hi asudevil, I don't know of any resource currently. If I find one I will post it. Sorry

Thanks nlim, It's true that it is strait forward for an attribute and had a really looked at it harder before posting I would have found that, my bad ... sorry. However for custom groups they don't show up in the list of available fields. So if we use the example above and I create a...

Create a metric using an applysimple. This is and example for SQL Server your DB may be different Sum(ApplySimple("datediff(dd,#0,#1)", [starttraveldate], [endtraveldate])) {~}