AggregateFunction = None

Hi everibody.

I use a AggregateFunction = None for a measure (price for article). When I go in a client Olap, every data is Null.

Where I wrong?

Tank you

Nothing is wrong. AggregationFunction = None means the data is not aggregated and only exists on leaves of measure group. Therefore all aggregated cells are NULL. This is how None is supposed to work.|||

Sorry Mosha. For first tank you, but.....

I read that leaf of a hierarchy take value from Fact table, then the total or subtotal don't exist, but value for leaf must me exist. Instead, I never see data

Bye from Florence

Marco

|||

There is important difference between hierarchy leaves and measure group leaves. The data is loaded at measure group leaves, not at hierarchy leaves. For more details about difference between the two you can read the following: http://www.sqljunkies.com/WebLog/mosha/archive/2006/04/29/leaves.aspx

|||

Tahk you Mosha. I try to understad......

Bye Bye

Marco

AggregateFunction = None

Hi everibody.

I use a AggregateFunction = None for a measure (price for article). When I go in a client Olap, every data is Null.

Where I wrong?

Tank you

Nothing is wrong. AggregationFunction = None means the data is not aggregated and only exists on leaves of measure group. Therefore all aggregated cells are NULL. This is how None is supposed to work.|||

Sorry Mosha. For first tank you, but.....

I read that leaf of a hierarchy take value from Fact table, then the total or subtotal don't exist, but value for leaf must me exist. Instead, I never see data

Bye from Florence

Marco

|||

There is important difference between hierarchy leaves and measure group leaves. The data is loaded at measure group leaves, not at hierarchy leaves. For more details about difference between the two you can read the following: http://www.sqljunkies.com/WebLog/mosha/archive/2006/04/29/leaves.aspx

|||

Tahk you Mosha. I try to understad......

Bye Bye

Marco

After deploying a Business Intelligence project how to recreate the OLAP security

During development the project is focus on schema and schema changes and test

security. When I I deploy the database to production, I end getting

the development security in the production database. How does one create

a script that recreates the security in the production environment so that I can

be reused it after the deployment. The synchronziation wizard is not appropriate

since it moves data as well.

In SQL

Server Management Studio you can access Script related menu commands from the

context menu. All management dialogs in that program also have Script button on

the toolbar. An object can be scripted and script re-executed on another

server.

Additionally you can import entire database as a BI Development project using. In

BI Development Studio - menu File | New | Project and choose the project of

type "Import Analysis Services 9.0 Database". That imported solution

can be adjusted and deployed onto another server.

|||

I not sure what is meant by context senstive menus? I was hoping for a faster method.

I know that what I ending up doing was for each role in the production database Roles Heading:

I right clicked on the properties of the role and then selected the "Cubes" page and then clicked the Script Action menu.

This took 3 hours to do for all of the production roles:

I am not sure I understand the second choice since I did this at the beginning of the project, removed all of the

production security, made hundreds of changes to cubes and dimensions and readded the development security interactively.

|||You actually did what i meant. Performance is another story.