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
---- ...
|
Totals for the week
Tue, 9 Sep 2008 13:31:02 -0700
Hi All!
The following query (Reporting Services) is calculating sales numbers for
Stores from Thursday to Saturday. The Totals for Week is intended to
calculate the entire current fiscal week (Sun-Sat); however, it returns NULL
values. I know that that is because I limited the days (5:7) in the subquery
...
|
MDX Query results Inserted into SQL table
Tue, 9 Sep 2008 08:19:01 -0700
Hello, after I formulate an mdx script that returns the results I want from
the cube using the SSMS, what is the process for getting the results to a
table in SQL server?
I would like to run the mdx code using SQL Agent, and then have the results
inserted into a table in SQL Server.
Thanks,
Jason
ht ...
|
