Querylog in MSAS 2005 does not work with read permission to develo
Thu, 21 Aug 2008 12:49:02 -0700
Hi,
I have given the following link which has more detail information in it,
querylog does not work with read permissions or even admin process on cube to
developers. It works only when we give olap admin permissions, can you please
help me how to work with if it can be work at read pemission level access?
...
|
Improve MDX query in 2005
Thu, 21 Aug 2008 05:17:01 -0700
Hello,
is there way how to improve this MDX query
member [Avg] as [Measures].[Count]/count([Atr1]*[Atr2]),
non_empty_behavior=[Measures].[Count]
select [Atr1].children * [Avg] on 0, [Atr3].children on 1 from MYCUBE
This query compute the average [Count]/[Atr2] of [Atr1] but it is very slow
(for exam ...
|
Incremental Processing with changing data
Thu, 21 Aug 2008 04:49:01 -0700
Good day
I have a cube in which small amounts of fact data (sales) are imported
daily. We have one partitian which we process incrementally. The case could
exist, however, that the sales for a specific day for a specific branch might
change. What is the best way of handling this?
Is it best to process ...
|
Report model using two SSAS cubes
Thu, 21 Aug 2008 16:16:15 +0530
Hi,
I have very simple question. I would like to build one report model using
two SSAS cubes. The two SSAS cubes have identical structure but connect to
two different data sources. Please help.
Thanks,
RK
...
|
MDX help for Totals & GT
Wed, 20 Aug 2008 19:37:01 -0700
Hi,
The following query gives 'Items Sold' by Region, State. (side by side)
SELECT
[Measures].[Items Sold] ON COLUMNS,
CROSSJOIN([Geog].[REGION_CD].Children, [Geog].[STATE].children) ON ROWS
FROM [SALES CUBE]
But I want to include 'Totals' & 'Grand Total'.
I tried the following MDX stmt and ...
|
Design Suggestion
Wed, 20 Aug 2008 16:21:01 -0700
Hi All,
I have a cube with a fact table containing sales data and multiple
dimensions. I have Sales Geography dimension, Sales District dimension and
Sales Group dimension (and some others, which is irrelevant for this
question).
Geography table is: Geography_Key, Geography, g_population
District table ...
|
SSAS 05 300 Dimension !!!
Wed, 20 Aug 2008 10:02:46 -0700 (PDT)
I am using excel pivot table to look at the cube but there are too
many dimension so there is lot of scrolling to find the dimension. Is
there any way I can group the dimension so it is categorized?
Below is the example:
Dimension Name:
Age
Gender
Martial Status
And so on ..
I want to create folder ca ...
|
|
|
ADOMD.NET connection to local cube file on 64bit Windows Server 2003
fails
Wed, 20 Aug 2008 08:10:10 -0700 (PDT)
Hi all,
Hopefully its clear from the title what I want to do, just connect to
a normal local cube file in a C# app I am writing.
I have tested a few scenarios, and mostly it works fine:
32 bit server connecting to an AS2000 or AS2005 instance - OK
32 bit server connecting to a local cube file - OK
64 bit s ...
|
SQL Analysis Services(dso.connect)
Wed, 20 Aug 2008 07:05:31 -0700 (PDT)
Hi,
I have a VB.NET application and we use to connect to Analysis Server
2000. My question is: do we need to Install Analysis services 2000 to
be able to connect the Server when we intall a VB.net Application.
because actualy if i install Analysis services 2000 the application
works but with out i cant connect ...
|
Create OLAP db based on another OLAP db
Wed, 20 Aug 2008 08:46:36 GMT
Hi All,
I want to create an OLAP db based on another OLAP db. I need to have two DBs for two different needs, but with similer data. I don't wont both will be processed against the relational DWH, because it is to heavy.
I need one to have a lot of aggregations, because it will be used for ad-hok reports, while ...
|
