Search results for query: *

...Ref1 on Fact1.A4_ID = Ref1.A4_ID join B4LookUpTable LookUp1 on Ref1.B4_ID = LookUp1.B4_ID where ( ( exists ( select * from B3ToA4RefTable Ex_Ref1 join B3LookUpTable Ex_LookUp1 on Ex_Ref1.B3_ID = Ex_LookUp1.B3_ID where Ex_LookUp1.A2_ID in (333) and...

OK, another problem caused here. The final template (i.e. not the filter report) has a hierarchy as the row ([All Merchandise]), and because the row is hard-coded to {stroke/colour} in the Filter Report, the final report is always at {stroke/colour} too - the level chosen in the original...

Sounds interesting guys, I'll give it a go and get back. Thanks, Richard

CMD MGR command: LIST ALL PROPERTIES FOR USERS IN GROUP "everyone" ; All users are in 'everyone', so you get all the users with their properties. Richard

Sorry, should have said this is a 7.2.2 project...Ta Richard

...Other Stock] The % metrics are compound metrics based on counts. For example [% sale floor stock] would be defined as: ([Sales Floor Stock Count] * 100.0)/[Total Stock Count] and [Total Stock Count] is defined as: [% sale floor stock]+[% warehouse stock]+[% On Order Stock]+[% Supplier...

You could change the ASP to put the user in Advanced Drill on return of report - this would give the drills across. We have completely changed the interface (hated those DHTML menus) and have a menu bar with buttons to go directly to the options are users require - and only those! This is...

Agree with kpescatore, as you are using Current Date, then use dynamic dates. Current date - 45 days. Simple. It will make for more efficient SQL too as you will get a "DateField = 'ccyy-mm-dd' clause rather than a subquery. I would only use the Applysimple here if youyr date table is not...

Agreed. Original post did not mention Documents.

You use a transformation table to do the transformation - therefore, it can cater for week on week by year etc without having to match up - you do not need to use dynamic dates, you can use your own date tables. For example, we have the same issue - Mothers day does not match up week on week...

That sounds just like what I want - do you happen to know where the setting is? Is it available in 7i (7.2.4) or only in 7.5 (not moving there for many moons yet). Thanks for your help - hope shines once more. PS: Don't worry if you don't know exactly what the setting is - I can query Support...

Ouch - this is kind of like asking "I've installed VB, where do I start?". A good place would be the MSTR COM Web API course. The PDF Files that come with the SDK contain lots of snippets, but probably not for the uninitiated.

Can you outline the structure of these agregate and the ref tables. I assume something like this: Attribute: Month - Table Ref_M Attribute: Day - Table Ref_D Ref_M: A_Month_ID A_Month_Desc Ref_D: A_Day_ID A_Day_Desc A_Month_ID A_Month_Desc (Don't actually need thuis one, but can save join if...

...to transform your "Count" to Metric "Count Previous Year". Then you have the ability to use a compound metric - ("Count"/"Count Previous Year")*100. In column 3. This is assuming you always want Year on Year (E.g: Run for 2003 - you would get 2003, 2002, %Yr 03 to 02 - run for 2002 you'd...

Assume your aggregates are at month. How are you filtering on the month for the report? Let me explain: We have a similar scenario, but with weekly data. For stock we only want a snapshot - latest position. If the user runs the report for the last 10 weeks for example, the dynamic dates...

Hi all, This is the problem (7.2.2), We collect Stock Daily and have aggrigates at both Week and Day (amongst others). Because we always want to see a snapshot of the stock, we use End Fact dimensionality. Sum([STOCK]) {~, [All Time]} With Dimesionality of Report Level Std Std and All Time...

MD: I would be happy if we could just know what things were so we can do read only type operations on the MD - this can be really usefull - Project Documentation and CMDMGR does not cover all. Another pain: Folder permissions - we do not use the personal folder solution that come with MSTR, but...

Me again. One really annoying thing (in 7.2.2 at least). We usually use local templates as they are report specific for the business here. However, we sometimes make use of shared (non-local) templates (Drill to Template etc). The thing that annoys me is that Drill Maps are associated to the...

1): Better thresholding options (probably available in 7.5 suite, but hey how many have made that leap - or will?). The ability to colour cell backgrounds, highlight whole rows/columns, Allow user to dynamically vary the thresholds at run time. 2): A better print solution from Web. With the MS...

Hi nlim, as far as I'm aware, both Mstr and Aspelle were to make fixes - something to do with Mstr not putting a data size parm in the header of the autoprompt (returning from server to client) and Aspelle thinking no size parm equals no data. We have been busy stripping down the wait/prompt...