Cube not refreshing?

AS and RS 2005

My cube is built on views both for dimensions and the fact table.

I am using reporting services and the report i have designed works fine except it does not update when i change the data. I can see the change in a select from the view so it is definitly there. It does refresh if i reprocess the cube. This happens in rolap as well as molap.

Any Ideas?

Thanks,

Jules

Moving to Reporting Services forum.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

why have you moved this?

does that mean it is reporting services that is caching the data?

It looks more like a problem with analysis services to me given that the report displays the correct data if a reprocess the cube.

Whats you thinking here.

Please help

Thanks,

Jules

|||

Most chances it is Reporting services problem. You can try and browse your AS cube using cube browser built-in in SQL Management studio to see if new numbers are avaliable.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cube Design - Number Max of Dimensions

Hi all,

Some cubes into my project have been designed containing 11 dimensions ? Is there a number max of dimensions? The performances look fine so far but I was wondering if it will be a good idea to split these cubes to have a limited number of dimension per cube.

Thanks a lot for your support

Juan

I think you're a long way off hitting the maximum:
http://msdn2.microsoft.com/en-us/library/ms365363.

The only thing you need to look out for when you start adding lots of dimensions to a cube is that aggregation design will take longer and the you're less likely to get good results using the Storage Design Wizard alone - you'll probably need to do Usage Based Optimisation to get the aggregation design you really need. It's also gradually emerging that putting all your data in one cube with multiple measure groups might not be the most efficient way of designing your cubes - see
http://prologika.com/CS/blogs/blog/archive/2006/06/28/1331.aspx

HTH,

Chris

|||

Chris,

Many Thanks for your feedback.

The tests of performance (processing of cubes) I have made meet our requirements.

Do you think that there will be an impact in the restitution of these cubes (with a lot of dimensions) via Excel (add-in) ?

Does the cube design with a lot of dimensions have an impact in the restitution performances ?

Thanks again.

Juan

|||

What do you mean by 'restitution', sorry? Do you mean query performance? If so, no there's no reason why a cube with many dimensions should perform worse than a cube with few dimensions, although as I said you need to be more careful with your aggregation design when you have many dimensions in order to get good performance.

Chris

|||

Sorry for my english...

I meant 'browse' the cube thanks to Excel (Add_in).

My tests of performance have been done to measure :

- performance to process cubes

- performance to access cubes with Excel

If I understood well, the design has a direct impact in the processing of the cube but not in the browsing of the cube.

Hope to be clearer...

Cheers

Juan

|||

Well, what I was trying to say was that adding dimensions to the cube doesn't necessarily cause worse query performance so long as you pay attention to your aggregation design. But it would not be true to say that cube design in general has no effect on query performance - it does.

Chris

Cube Aggregation

Simple question about OLAP Cube? Once the dimensions and cube are designed, when we process the cube, what aggregations are stored in the cube. Does the cube aggregate function defined in the measures like AggregateFunction: SUM, COUNT or is it more than that.
Another question—if the user wants to define there own aggregated function, say for example a statistical function such as standard deviation (STDEVP a MDX function) and wants to store the aggregation of that in the Cube while processing, is that possible?

SQL Server 2005 Step-by-Step has a good walk-through on aggregation design. I believe this is in Chapter 7. Basically, you can access the aggregation wizard on the Partitions tab of your cube designer. There's quite a bit to aggregations so, again, read that chapter to get the broader picture.

Regarding STDEV or STDEVP, I believe the MDX function could be used in a calculated member to give you what you are looking for. However, it's not clear to me if it calculates the data at the level of the set you specify or if it performs the calculation across the leaf level members. Either way, you could run into an issue with calculating standard deviation across aggregated data. I recommend you assemble the components of the formula yourself, stored those as part of the cube, and perform the final calculation in a calculated member.

B.

Cube administration

What are the activities that a cube administrator does?
Cube has been designed by a developer.
Cube processing is taken care of by the ETL task.
Building partitions and setting permissions/access to cubes are a couple of
things that might need to be done by an administrtor.
Are there any other tasks?
Is it usual to take a back up of the cube? can it just not be rebuilt from
the data base if needed?
thanks
Message posted via http://www.droptable.com"Sara via droptable.com" <forum@.droptable.com> wrote in message
news:edab3fed237f47b8a60ec9aa06305e10@.SQ
droptable.com...
> What are the activities that a cube administrator does?
> Cube has been designed by a developer.
> Cube processing is taken care of by the ETL task.
>
> Building partitions and setting permissions/access to cubes are a couple
> of
> things that might need to be done by an administrtor.
> Are there any other tasks?
Read olapdmad.chm::/agadmintasks_50z7.htm in BOL.

> Is it usual to take a back up of the cube? can it just not be rebuilt from
> the data base if needed?
Yes if you make a "full process" every time you process the cube. Make only
a backup version of your cube so that you can easily rebuild it if a crash
occurs.
If you make an incremental update and some of your data may have benn
deleted from the data source (Old customers, or past years invoices for
example),then you can consider tto take a backup of your cube, even if I
prefer to take a backup of the tables instead of a backup of the cube.
Backup a cube may be useful if you want to transfer a cube from one analysis
server to another

> thanks
Bye
Francesco Anti

CSV rendering is missing first detail row

For one report we've designed, an HTML rendering will produce 3 detail
records. When this same report with the same parameters is rendered in CSV,
the first detail row is missing from the output. All other aspects of the
export seem to work as expected.
This occurs with several reports we have but not all of them. This happens
when previewing in VS.NET, RS Manager, and on our live Web site. Other
formats do not drop the first detail record.
Is there any resolution to this problem?FYI: I experienced the same problem you described. Through trial and error I
determined that what was causing the problem was that I was grouping the
Details section of the Table. To work around this I added grouping to the SQL
code and removed grouping from the report detail.
Brad
"John Demar" wrote:
> For one report we've designed, an HTML rendering will produce 3 detail
> records. When this same report with the same parameters is rendered in CSV,
> the first detail row is missing from the output. All other aspects of the
> export seem to work as expected.
> This occurs with several reports we have but not all of them. This happens
> when previewing in VS.NET, RS Manager, and on our live Web site. Other
> formats do not drop the first detail record.
> Is there any resolution to this problem?

CSV rendering is missing first detail row

For one report we've designed, an HTML rendering will produce 3 detail
records. When this same report with the same parameters is rendered in CSV,
the first detail row is missing from the output. All other aspects of the
export seem to work as expected.
This occurs with several reports we have but not all of them. This happens
when previewing in VS.NET, RS Manager, and on our live Web site. Other
formats do not drop the first detail record.
Any ideas? I can't seem to find anyone else that has run across this
problem in the groups.I continue to have this problem and cannot find any answers. Is there a
problem with the CSV rendering extension?
"John Demar" wrote:
> For one report we've designed, an HTML rendering will produce 3 detail
> records. When this same report with the same parameters is rendered in CSV,
> the first detail row is missing from the output. All other aspects of the
> export seem to work as expected.
> This occurs with several reports we have but not all of them. This happens
> when previewing in VS.NET, RS Manager, and on our live Web site. Other
> formats do not drop the first detail record.
> Any ideas? I can't seem to find anyone else that has run across this
> problem in the groups.
>|||John,
I am also seeing the same results with the missing first line. Does anyone
know if this is a known issue or just a setting that can be set?
"John Demar" wrote:
> I continue to have this problem and cannot find any answers. Is there a
> problem with the CSV rendering extension?
> "John Demar" wrote:
> > For one report we've designed, an HTML rendering will produce 3 detail
> > records. When this same report with the same parameters is rendered in CSV,
> > the first detail row is missing from the output. All other aspects of the
> > export seem to work as expected.
> >
> > This occurs with several reports we have but not all of them. This happens
> > when previewing in VS.NET, RS Manager, and on our live Web site. Other
> > formats do not drop the first detail record.
> >
> > Any ideas? I can't seem to find anyone else that has run across this
> > problem in the groups.
> >