Dear,

I recently had a similar issue.

I could solve it by applying the StrToValue function to the KPIValue("myKPI") variable in the KPI Status calculation.

Franky

Dear,

If you want to provide a few fixed reports that don't require many updates or will not evolve over time, you may not need a cube.

However, many users will likely...

Thanks for this brief overview !

Franky

Dear,

I'm not sure what you mean with 'ignoring the date dimension'.

Possibility 1 :

You can create a distinct count measure on the combination of the country product combination. For doing that,...

It is not really a good idea to introduce an attribute, in your case the operational key, with such a cardinality (ca. 50 million) in the cube.

However, you could add...

I'm not sure if you want to count something.

So I think the dimensional model is not complete yet, or a cube is not the solution for the question that must...

Dear,

You can not use a string as a measure because a string can not be aggregated.

How does your dimensional model look like ?

It is not very clear, if you have currently a performance problem or not, so I'll provide a generic answer.

Some maximum capacity numbers for SQL Server Analysis Services, see here...

In the third "When .. " row, you have a ' instead of " .

Franky Leeuwerck

Great article Adam !

Thanx for sharing.

Franky

Hello,

You could add a "Created" date column to your (fact) table with a default value set to getDate().

Example

CREATE TABLE myTable (

column1,

etc...,

[Created]...

Some suggestions :

1.You can add an attribute 'Decade'. That way, your user can easily select the Decades that are relevant. Add the Decade on top of a Decade-Year drill down...

Solved:

When using ratio's (percentages), you should use the "Band by value" scoring pattern. In such case 'a worst value' is not needed in the KPI configuration wizard.

Great idea !

Yes, sure you can reuse your many times for several facts.

Examples :

- Date dimension for FactInvoices (invoice date, ship date), FactSubscriptions (subscription date)

- Product dimension for FactSales (sold product), FactPurchases...