hello,
I wonder if i could call a queries to OLAP cube
from stored procedure ?
Can someone show me the example ?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20148977.html
Hello, can anybody indicate the MDX to calculate Unique Count to date ?
Having two Periods
Period Unique Count Unique Count to Date
First 10 1...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20965114.html
some one please help me,what do i have to do now
when i use query to select * from tablename
it show this errors :
indexs does not exist...
and it can't find the CDX and MDX file
what do i hav...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_21771728.html
In my cube, I am trying to find how a measure value relates to the sum of values as percentage (% share of total). My MDX query below parses, but doesn't account for the WHERE clause - I want to o...
http://www.experts-exchange.com/Database/OLAP/Q_23272095.html
Dear Friends,
I have this calculated member that If I execute for begin of the year like 2007-01-02, takes 2 seconds, but If I executed for a date in the end of the year like 2007-12-31, it takes ...
http://www.experts-exchange.com/Database/OLAP/Q_23632818.html
I have a table that shows Cumulative Remaining Work for Work Items for one week, I need to create a new column that will show the value for the previous week.
Thanks in Advance
http://www.experts-exchange.com/Database/Reporting_/Q_23670125.html
Hello, I am trying to create a time based hierarchy for a measure. For instance, I have a measure called system qty. I would like to have a drill-down hierarchy for Jul 2008, Aug 2008, Sep 2008,...
http://www.experts-exchange.com/Database/OLAP/Q_23717268.html
Hiya all,
I'm fairly new to the MDX world so appologies if the question seems a wee bit daft. I'm looking to determing the average of a measure over several weeks, what the lads are looking for ...
http://www.experts-exchange.com/Database/OLAP/Q_23637503.html
I need to do a NON EMPTY CROSSJOIN where I need to return data from multiple levels of 2 dimensions. When I try to run this, I get this error "Formula Error - duplicate dimension across (independ...
http://www.experts-exchange.com/Database/OLAP/Q_23879217.html
Hi,
If the *.mdx files lost, I used to set the byte number 28 to 0 in *.dbf file.
But Dbase 7 changed DBF file structure. How can I do with it?
Or I think using BDE API is better than to modify ...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10096016.html
