Search results for query: *

I was just browsing for the first time in a while and saw this post. Are you still getting the error? If so, can you possibly post exactly what it says? I've never gotten that message using object manager. I'm currently working with 8.0.2 against Oracle 10g though. Nate

I don't think you can show the value returned for that filter in the web or print preview. What you would pick to show in the header or footer for printing is the filter details, and those details (at least in 7.5.3 and below) would just show the Apply Comparison logic, not the value returned...

One more thing to add to iolaper's response, is that if you can't add the column physically to the database table for whatever reason (dba isn't in an agreeable mood) then you could create a view that joins the tables together. following what iolaper said, it would still be like adding a column...

Has anyone used the OLAP Provider tool from MicroStrategy to interface with Hyperion Essbase cubes? I can't find any documentation that indicates this is possible (other tools like Cognos or Business Objects are, not Essbase though). Just thougth I would try here. :-) Thanks! Nate

The logic for handling SCDs (with a type 2 response) is executed in the database but you should be able to display different versions of a record in MicroStrategy, if that is what you're asking. Let me give you an example. Lets say you've got a store in your retail chain, and its name is...

Hi Teccum, Glad you got it working. :-) I'm not sure if you meant to have this part in the front of your DSN, the "Mycomputer\" in front of the mapped drive letter, Z:, but if you did, that might have been the problem. If you're still curious, I would try it like so: Z:\Program...

Try creating and specifying the Tutorial Warehouse DSN on the I-Server machine. I'm pretty sure you need to have the DSNs for all your projects that the I-Server will access on the I-server itself. Nate

All good suggestions. One other thing to consider is that when you model these fields into MicroStrategy, if you haven't done it already, you will probably want to set up hierarchies, and these will allow you to pull gradually larger sets of data, starting with smaller ones initially (usually)...

Hmmm...ok. I see the problem now. Sorry, I was confusing filters for year to date transformations with the type of transformation you're asking for, which is transforming this year to last year. I don't know of a way right now to do that type of transformation in a filter. I would suggest...

Sorry for the delay. Can you try adding the quarter attribute to your report, filtering for the current years completed quarters (e.g. Q1-Q3 2004) and send the sql again? :-) Also, can you send the description of your INVOICE_EFFECTIVE_DAY_DIM table so that I can see what columns you have in...

I might not understand what you're asking for. If you put quarter on the report, with those three metrics, you should be able to get the variance for all the quarters that show up on your report. MicroStrategy should repeat the three metrics for each quarter (with the correct values for each...

If you've got the filters getting your data as desired, then you can just add them to metrics. Create two metrics, one with a filter for Q101 (call it M1) and one with a filter for Q201 (call it M2). Then create a third metric called a compound metric that gets the variance between quarters...

Have you tried creating transformation tables (or views) in the database and transformation schema objects which point to those tables in MicroStrategy? You could then use those transformation objects in various metrics, like your Revenue metric. On a report, you would then place the Revenue...

Sorry. I should have specified I was thinking of Value Prompt, Numeric type when I gave the sql above. If it's working the way you are doing it, then I don't see a problem. :-) In fact, I might be able to use your approach with some things I do. Previously, I had problems using "Qualify...

Hmm...ok. You might also need to change the filtering from IGNORE to STANDARD (or absolute) ... on the AD BLOCK level of those metrics.

It looks like your dimensionality on the "per basket" metrics might be the problem. Open up the level (dimensionality) pane, and try changing the AD BLOCK grouping to STANDARD. From what you wrote, it looks like you've got the GROUPING set to NONE. HTH, Nate

Not sure if this is what you meant or not, but you might be able to use the static report you mentioned at the end as a intermediate report between the filter report and your final report. In other words, create the filter report, use it as a filter in your static report with all the...

You might need to make sure you've got some sort of default value in those prompts. That way, you won't have to answer it. Also, from your query above, it looks like you're not restricting on any fields... "where #1 and #2" ... should that be something like ..."where gtn = #1 and btn = #2"?

Create a custom filter using the "Advanced Qualification" window, and add in something like the following ApplyComparison function. ApplyComparison("#0 in (select max(date) from user e join cycle c on e.id = c.id where gtn = #1)",[Date]@Id, [GTN]@Id) Might be other ways as well... hth, Nate

If you're having problems getting that qualification (e.g. [% Sales Floor Stock]<=50) to apply to more than one pass in your report, would you be able to run that qualification in a seperate report at the (stroke/colours) level and use that as a filter for the real report? HTH, Nate