MDX: Percentage of Total
Sun, 14 Sep 2008 12:39:00 -0700
Hi,
I would like to create an MDX calc for calculating "percentage of Parent"
for a measure like 'Sales_Amount' across all different dimensions in the
cube. Not just a PRODUCT dimension.
Some of the dimensions are multi level like 'Geography' Country=> State=>
County.
Also, the calculation should work w ...
|
Users in Database when Rebuilding the Cubes
Fri, 12 Sep 2008 13:06:42 -0700
Does everyone have to out of the cube in order to rebuild (fully reprocess)
the cube?
I thought that users could still query the cube when a reprocess was active.
Then when the new cube was built the queries would be using the new cube and
the old cube would go away.
Is my understanding wrong? Please ad ...
|
Friendly field names on drill through action
Thu, 11 Sep 2008 17:28:34 GMT
I created a drill through action for my cube. The drill through action works
fine, except the headers for the fields are not friendly. They are named [
$APT Agency].[Agt Nam]. Instead I want the header to be 'Agent Name'. How do
I do this? Is there a property somewhere to control this?
...
|
OWC and MDX
Thu, 11 Sep 2008 16:19:49 +0800
Hi all,
I am using OWC to browse Cube data. But when the data size is creasing, the
performance is very slow. So I prefer to use OWC to query a subset of cube
data. But how can I use OWC to base on a SELECT statement of MDX? Seems OWC
can only query the cube, we can only supply the cube name, but not a MDX ...
|
Returning the Current member key
Wed, 10 Sep 2008 15:15:01 -0700
Hello, can someone please tell me how to retrieve the CurrentMember key?
I can retrieve the name, i.e.
[Time].[Fiscal Month].currentmember.name
but I would like to retrieve the Key instead.
Thanks,
Jason
http://www.lonestarfinancing.com
...
|
Adding New Dimension into Cube/Partition
Wed, 10 Sep 2008 11:23:03 -0700
Hi,
I have many cubes with billion records. Now my cube enhancement function is
getting really very time consuming when ever I want to New Dimension to the
cubes.
The challenge is when ever we go and add new dimension, we have to reprocess
whole cube and its taking long time to process many cubes for bil ...
|
Extranet access to OLAP cube
Wed, 10 Sep 2008 10:52:15 -0700 (PDT)
Hi,
We have a SQL Server 2005 Server which runs Analysis Service server.
Users in the company are using Management Studio to access the cubes.
We are planning to give access to users that are outside company
firewall. Is there a way to make cube available through Web?
Thanks for any suggestion.
-Oliver ...
|
|
|
Assigning a time period to a measure
Wed, 10 Sep 2008 07:26:01 -0700
Hello,
I will use an example from the Adventure Works cube to highlight what I am
trying to do:
I added this code to the calculations section:
CREATE MEMBER CURRENTCUBE.[MEASURES].[Total Sales Amount 2002]
AS ([Measures].[Total Sales Amount], [Date].[Fiscal Year].&[2002]),
FORMAT_STRING = "Currency", ...
|
Role using AD Security Group
Tue, 9 Sep 2008 14:41:01 -0700
I have an Analysis Database with one cube and several dimensions. I wanted
to create a read-only role using AD Security Group. However, users cannot
connect to the cube if I am using AD Security Group to add them. When they
are added individually on the role, they are able to view the cube. Can you
pleas ...
|
Need help with MDX Query involving set intersection
Tue, 9 Sep 2008 14:09:10 -0700 (PDT)
I need some help with this MDX query. I need to get the # of InPatient
Visits (including Short stay, excluding cancels) within six months of
also having an OutPatient Visit or Emergency Visit
Among the dimensions I have (with sample members) are
Patient
----------
LastName
FullName
...
VisitType
---- ...
|
