Percent column needed in Excel 2007
Tue, 24 Jun 2008 12:55:39 -0400
Hello, I have an OLAP cube in sql2005 and an Excel 2007 pivottable which
reads the cube. I have totals for months columns of my sales, but I need to
know the percent who that sales represents of the grand total. I can't see
where add this calc.
Example:
CUSTOMER | JAN | FEB |MAR | APR | TOTAL | PERC ...
|
Analysis Services 2005 Actions From Excel 2003 for Drillthrough
Tue, 24 Jun 2008 05:53:01 -0700
I'm interested finding out how to call or excecute a drillthrough action in
SSAS 2005 from Excel 2003. I have a large rolap dimension and am unable to
perform drillthrough using VB code. It works great if the dimension is MOLAP,
but not ROLAP.
When I use Excel 2007 I'm able to use the drillthrough action s ...
|
SSAS 2005 - fact table with 2 time stamps - count for any point in
time
Sun, 22 Jun 2008 18:21:44 -0700 (PDT)
Hi there,
I've got a fact table (car rental episode) that has start and end date/
time stamp:
RentalId
StartTime
EndTime
Start and end time link to Time dimension table (via StartTimeId,
EndTimeId) that has Year, Month, Day, Hour, Minute columns. I've got
time dimension created from that table
I want ...
|
The CURRENTMEMBER function expects a hierarchy expression for the 0
argument
Sat, 21 Jun 2008 12:16:20 -0700 (PDT)
I have a dimension dimZoneProduct with a hierarchy
Zone ? Product
. Zone
.. Product
I want to know what percentage has each product by zone
Zone A 20000 100%
Product 1 15000 75%
Product 2 5000 25%
I have the following dmx expresion
With Member [Measures].[ZoneProductP ...
|
Recommendation for a good reference book
Fri, 20 Jun 2008 20:30:32 GMT
Please recommend a good reference book as a starting point for various OLAP
concepts and objects and especially what is a measure and how it works.
I am working with a system that has a series of Excel templates to allow
users enter and retrieve data from SQL and OLAP. We have a query engine that
runs in the ...
|
Automate cubing?
Fri, 20 Jun 2008 12:54:50 -0700 (PDT)
Hi,
I got a working cube, now I need to automate it. How is it usually
done? a daily process scheduled to do an incremental cube from a
datamart? is SSIS the typical solution for that?
thanks! ...
|
Limiting Drillthrough records
Fri, 20 Jun 2008 12:53:07 -0700
Currently when a user uses drillthrough on a measure, all the fact records
that made up that slice are displayed. Sometimes when the balance measure is
10, more than 1000 records come back, but only 10 records have the measure
balance of 1. The user is expecting only 10 records (the non zeroes).
Is ther ...
|
|
|
Measures not totally correctly with Multiple Measure Groups
Fri, 20 Jun 2008 12:50:01 -0700
When I have two measure groups (GroupA and GroupB) and GroupA has a dimension
not in GroupB, then when slicing by that dimension on the GroupB measures,
the total is correct, but all the members have the value of the total. This
is confusing users who are not paying attention and are slicing on dimension
ag ...
|
Excel 2007, SSAS2005, Calculated Member Format Does Not Pull Into Sheet
Fri, 20 Jun 2008 11:28:39 -0400
All:
I have designed a cube wherein I have several calculated members used as
measures where I set the format to be currency. Although the formats from
all other dimensions and measures gets pulled through to the Excel pivot
table, the calculated measure formats do not. I haven't found a bug
report - is ...
|
I need to be able to see all levels, all the time
Thu, 19 Jun 2008 18:53:24 -0000
Hi
I have created finance OLAP cube in Analysis Services 2005. I am trying to
find out how I can show all general ledger accounts (all levels in
dimension) with and without transaction. Can you help? I need to be able to
see all levels, all the time.
Best regards, Benedikt VTL
Computer depart ...
|
