IT Job Guru
Tue, 12 Aug 2008 12:19:07 -0700 (PDT)
Are you looking for a Job in India??? You have experience in Java,
Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a
minute and log on to www.itjobguru.com/forum/index.php. It has all
the
latest Jobs and also the Questions that will be asked in Interviews.
Or are you planning to do a cert ...
|
MDX question on combining result sets
Tue, 12 Aug 2008 09:56:11 -0400
Hi, all...
I have the following query, which breaks out sales by country...
select [internet sales amount] on columns,
[Date].[Calendar].[Month] * [Customer].[Customer Geography].[Country] on
rows
from [adventure works]
where ([Date].[FY 2003] )
It gives me this, no problem at all
July 2002 Australi ...
|
MSAS2005: Bug in Distinct MDX function
Tue, 12 Aug 2008 00:22:01 -0700
I have MSAS2005 with SP2 and the latest cumulative update 8.
When I run the following MDX
WITH MEMBER [Geography].[Geography].[CM] AS '10'
SELECT
{} ON COLUMNS,
{Distinct(
{[Geography].[Geography].[(All)].AllMembers,
[Geography].[Geography].[CM]}
)} ON ROWS
FROM [Adv ...
|
MDX Question
Mon, 11 Aug 2008 18:59:15 -0700 (PDT)
I have a question regarding creating subtotals in MDX.
Say we have a cube ("rent") with the following dimensions:
Year
Month
Version
Region
Office
Rent Classification
Rent Measure
And I have the following query:
SELECT
NON EMPTY
{
{[rent classification].[all rent classifications].children}
*
{[ ...
|
Possible to process a cube being used ?
Mon, 11 Aug 2008 10:53:08 -0700
Is it possible to process a cube while it is being browsed? If there is some
setting up to do this, please point me in the right direction.
I have built a sales cube that contains the sales from a few hundred
branches. I want sales from each branch to be added to the cube when the
manager has closed the day ...
|
Help with modeling one to many relationship
Mon, 11 Aug 2008 10:26:41 -0700 (PDT)
I am new to OLAP. I need to build a cube for the following example. I
have data for respondents and each respondent has an Id associated
with it. I have "Gender" (Male, Female), "Marital_Status" (Married,
Single, Divorced) and "State_Of_Tax_Filing" (AL...MA, NY etc)
information of every respondent. Gender and Ma ...
|
Multiple Time Calendars with Mosha's Periodicity Approach
Mon, 11 Aug 2008 09:23:03 -0700
What are some approaches for implementing a requirement for numerous
different vendor defined calendars (time)? Appending the calendar
variations to the single time dimension may not be feasible... I have
already implemented Mosha's dynamic Periodicity approach and I really like
it. Ideally I'd like to k ...
|
|
|
XMLA / MDX query for tuple
Mon, 11 Aug 2008 09:18:36 -0700 (PDT)
Hi,
I am trying to create a custom action based on a pivot table and I
need the tuple of the cell selected. For instance,
I have car brands in rows, car colors in columns, and the number of
sales is selected as a measure.
Car Color
Car Brand Red Green Blue
--------------- ...
|
asynchronous query (oledb)
Mon, 11 Aug 2008 12:50:47 +0200
Some queries make a long time to execute, I want to abort them.
So I tried to make the query asynchronous.
I used code below to set property on DBPROPSET_ROWSET before calling
Execute()
DBPROP* pProperty;
pProperty = &rgDBProperties[0];
pProperty->dwPropertyID = DBPROP_ROWSET_ASYNCH;
pProperty->vV ...
|
MDX query for cube LAST_DATA_UPDATE property?
Mon, 11 Aug 2008 03:48:35 -0700 (PDT)
Hello,
In SSAS 2000 we have a need to write an MDX query that returns value
of the last time the cube was processed (updated). Currently, there's
a vb code that does that, but we'd really like to be able to do it
with mdx. This is the vb code:
Set cn = CreateObject("ADODB.Connection")
cn.Open "provider=m ...
|
