Viewing 15 posts - 1 through 15 (of 44 total)
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.
June 4, 2013 at 5:26 am
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...
January 23, 2012 at 5:22 am
Thanks for this brief overview !
December 9, 2011 at 4:09 am
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,...
November 17, 2011 at 1:49 pm
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...
October 10, 2011 at 8:41 am
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...
September 21, 2011 at 9:03 am
You can not use a string as a measure because a string can not be aggregated.
How does your dimensional model look like ?
September 21, 2011 at 8:23 am
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...
September 20, 2011 at 1:08 am
In the third "When .. " row, you have a ' instead of " .
September 15, 2011 at 8:13 am
Great article Adam !
Thanx for sharing.
June 20, 2011 at 3:59 am
You could add a "Created" date column to your (fact) table with a default value set to getDate().
CREATE TABLE myTable (
June 6, 2011 at 1:56 am
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...
May 10, 2011 at 1:57 am
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.
April 21, 2011 at 7:11 am
Great idea !
April 19, 2011 at 1:50 am
Yes, sure you can reuse your many times for several facts.
- Date dimension for FactInvoices (invoice date, ship date), FactSubscriptions (subscription date)
- Product dimension for FactSales (sold product), FactPurchases...
December 15, 2010 at 1:43 am