Search results for query: *

Hi, We have recently purchased Cr Enterprise Embedded and plan to deploy our reports on the intranet with this. I have got an asp app working where you can select a report - it loops through the report parameters (if any) and then displays the reports once the params have been given. This...

Hi, I trying to deploy our reports on the intranet using Crystal Enterprise Embedded (RAS). I am using a very simple method of doing this - Using the code they have supplied. I simply select a report using hyperlinks and URL encoding which then takes the user to crystals standard default...

Hi I cant seem to find an example to trim or substring an full URL address to just the file name and extension. for example a variable that holds the address URL: C:\Reports\Finance\test.rpt to just return a variable with the file and its extension: test.rpt any help would be great. Thanks

Thanks misscrf. that is how i set up the cube and still have still have the sae problem.

I know this is possible when you use crystal reports to view the cubes but I am not sure in the cube itself. THe terminology used in Crystal is "suppress empty rows/columns" maybe its best to serach for something like this on mircosoft site. sorry can not be any more help.

Hi, I have a Time Dimension which allows me to select a specific YEAR, or YEAR & QUARTER or YEAR & QUARTER & MONTH, or YEAR & QUARTER & MONTH & DAY. Is there any way that I can have a range of dates? Is it possible to have 2 time Dimensions for example which did the following: a start...

Hi, I have a finance cube where the financial year runs from the 1 February to the 31 Jan. When creating a time Dimension you are able to select when the year starts (which is great for time dimensions such as financial years!) ... However... when I query my db direct for the figures for...

I am having a lot of problems with selecting date ranges (or event just two dates) for my cube in Crystal reports (v.9) using date parameters. I have a Date column (data type as datetime) in my orginal database table. When this data is drawn into the cube - the data type of the Date...

I am having a lot of problems with selecting date ranges (or event just two dates) for my cube in Crystal reports (v.9) using date parameters. I have a Date column (data type as datetime) in my orginal database table. When this data is drawn into the cube - the data type of the Date...

I have tired this with little success...unfortunately the measures affect those measures from the "other" cube. I thought MDX would be the best way forward?

Is it possible to write MDX code for a Dimension (in the "All member formula"??) which will specify that only certain measures are affected by that dimension - say measures A,B and not C for example. This is becuase I have 3 measures "Actual", "Budget", "Full Year Budget" and I have a...

Is it possible to write MDX code for a Dimension (in the "All member formula"??) which will specify that only certain measures are affected by that dimension - say measures A,B and not C for example. This is becuase I have 3 measures "Actual", "Budget", "Full Year Budget" and I have a...

Unfortunately I cant really reference an example in Foodmart. Hope this helps...... I eventually hope to achieve having three measures in a virtual cube: "Actual", "Budget" and "Full Year Budget". The dimensions I have are: - Account No_ / Name - Cost Code - Sub Cost Code - Time/Dates -...

Thanks MDXer, I have created a virtual cube and still the Dimension filters affect all measures/columns. Can you please give me some direction on how to achieve this? Do I have to use Private Virtual Dimensions for those dimensions I only want to be affected? Thanks david

I need to do the same thing....where and what is BOL ?

Hi, I am new to cubes and need some help with Dimension filters and the way these affect my measures. I have three measures in my finance cube: "Actual", "Budget" and "Full Year Budget". I also have several Dimension filters which affect these - such as "account codes", "cost codes" etc...