Search results for query: *

I think you can do this by creating 2 subqueries. In the tabular model of your query, add two new tabular models as children. In the first child, create your query as you have done now and already include the "minimum" calc. In the second child you fetch all combinations of color numbers and...

In transformer, select file, currency table. In your case, you probably only have one currency so select <Base default>, right click. Select override the country code and set the currency symbol you want to use. HTH, Willem

You can start by reading the PowerPlay User Guide (pp_usr_gd.pdf).

I've been working intensively with both vendors for a long time. I agree more or less with DoubleD but all has changed now with the arrival of ReportNet! Although not perfect (perfection is not of this world :-) is is by far the best tool on the market. And much more is to come with the...

Regular timing defines when then calculations are done. Example: calculate a ration of two measures. after rollup -> first sum everything, then calculate the ratio (divide the two sums) befor rollup -> first calculate all ratios and then sum them Time state roll-up allows you to have a special...

Subsets allow you to define a custom set of categories. The advantage of subsets is that they are dynamic i.e. they are updated whenever a change in the cube data affects the categories in the subset. This allows you to create 'standard' reports (using reporter mode) that are updated...

Have a look at the following report. It does what you want + it also provides the rank for the last year. The report runs against the sample GO Sales and Retailers. Just copy it and then in report studio select Open Report from Clipboard. When you see a prompt to enter a year, enter 2005. HTH...

Are you using the folliwng syntax (please note the curly braces!)? It works fine in my case. datediff({n},[date1],[date2]) Willem