Recent content by tomgao

yes the people who are viewing them are actually clients who are not IT savy...

Hi friends, Whenever I have created a local cube and have created an excel report from the local cube and after I send this report + the local cube to a client. I find that they often save the report + local cube to a different directory. The problem is that the excel actually stores an...

Hi friends I have a funny situation. I have a period dimension which contains Year, Qtr, Month. I also have another Time dimension which contains Mth1 .. Mth25. The 2nd Time dimension matches that of the 1st Time dimension ie. Mth25 is 2005.April. and Mth24 is 2005.March and so on... However...

his asking for local cubes

Hi guys I have built several cubes. However I would need to create local cubes from the built cubes in Analysis Services. As a result I need to work out the DDL for my existing cubes. However the cube contains many mdx calculated members. I was wondering if it would be easier to simply generate...

Hi guys. I want to create a top 20 product list from a few thousand products. I want the rest of the products to be grouped into 'others'... I also want the products to be ordered by the facts in the cube. Thus the product dimension would dynamically change depending on the Time dimension...

I'm not talking about parallel period. You can't parallel period this as far as I know. I need to specify begining of the year which is always variable ? Thats why you can only use ytd for the current year. How can you do it with parallel periods? how can you specify begining of the year like...

Hi guys. I need to calculate YTD-P which is for the last year ie. 2004/Jan -> 2004/June or in other words x/Jan -> x/June depending on the selected dimension. this is so that I can compare with the current year's YTD The problem is there's no way that I can work out how to do this in mdx...

Hi all I am trying to perform Pervious Year To Date Total (which is like YTD but for the previous year. ie. ytd would work for this year's jan -> whatever month. But I need a total from Last year from jan -> whatever year to do comparision), However I've ran into the following issues. Since...

I actually need to do something similar please let me know the outcome. Thank you Tom

Hi guys I'm investigating whether if its possible to Dynamically create a cube. Then Process this cube before exporting it to a .cub file. I know that DTS in sqlserver is able to process a cube given at a scheduled time interval. But I'm not sure how I can export a cube to a offline .cub file...

what do you mean ?

that takes a great deal of time :( is there another solution this frame is very annoying

I have the same problem I need to know too

When export to word format crystal report puts the exported report text fields into little text area boxes in msword. This doesn't allow users of the word document to edit the text as the textbox in msword does not grow and adjust to the text. Is there a work around for this ? I use CR 10...