Can MDX or latch a value based on a signal?

Dear All,

Persume that I have a cube with the following measures and dimension:

DimTime, measures.LatchSignal, measures.Voltage

0,1,4

1,0,5

2,0,6

3,0,5

4,1,3

5,0,7

6,0,5

7,1,6

8,0,7

Is there anyway I can repeat the value of voltage on and after the time when latch signal = 1, so that the result is rendered as follows:

DimTime, measures.LatchSignal, measures.Voltage, measure.latchedVoltage

0,1,4,4

1,0,5,4

2,0,6,4

3,0,5,4

4,1,3,3

5,0,7,3

6,0,5,3

7,1,6,6

8,0,7,6

Thanks and regards,

Tony Chun Tung Siu

Hi Tony!

Why do you try to make it in MDX. What the problem do you solve?

I would make it in DSV in oder to get

0,1,4,4

1,0,5,NULL

2,0,6,NULL

3,0,5,NULL

4,1,3,3

5,0,7,NULL

6,0,5,NULL

7,1,6,6

8,0,7,NULL

then apply lastnonempty aggregation function for the measure latchedVoltage

|||

Hi

I just wanna plot a graph for such signal implementation. This works!.

Thanks

Tony

Can I use Reporting Services 2005 against a Analysis Services 2000 OLAP cube?

Is it possible to create reports in SQL Server 2005 Reporting Services
against OLAP cubes based on Analysis Services 2000? Any limitations?
Any things I should know about?
I've tried to upload a report made in the SQL Server 2005 Business
Intelligence Management Studio to a 2000 edition Reporting Services,
and that didn't work out. (No surprise there, I just wanted to try it
out to see what happened. ) But would there be any problems using a
2000 OLAP cube as datasource?
All comments appreciated.
Kaisa M. Lindahl> Is it possible to create reports in SQL Server 2005 Reporting Services
> against OLAP cubes based on Analysis Services 2000? Any limitations?
> Any things I should know about?
Yes and there are known limitations. See
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/olapasandrs.asp.
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:1133378489.639395.34470@.g44g2000cwa.googlegroups.com...
> Is it possible to create reports in SQL Server 2005 Reporting Services
> against OLAP cubes based on Analysis Services 2000? Any limitations?
> Any things I should know about?
> I've tried to upload a report made in the SQL Server 2005 Business
> Intelligence Management Studio to a 2000 edition Reporting Services,
> and that didn't work out. (No surprise there, I just wanted to try it
> out to see what happened. ) But would there be any problems using a
> 2000 OLAP cube as datasource?
> All comments appreciated.
> Kaisa M. Lindahl
>|||Are you thinking about the last bit ("Moving Towards SQL Server 2005"),
or using Reporting Services against OLAP cubes in general? I've already
made a few set of reports in RS 2000 based on AS 2000, so I've figured
out the limitations there. I just want to know if there are any
problems developing reports in the 2005 designer against a 200
datasource.
Sincerely,
Kaisa M. Lindahl|||What I was eluding to is:
RS 2005 & AS 2000 = RS 2000 & AS 2000
I am not aware of any aditional limitations.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:1133470523.084460.320180@.g47g2000cwa.googlegroups.com...
> Are you thinking about the last bit ("Moving Towards SQL Server 2005"),
> or using Reporting Services against OLAP cubes in general? I've already
> made a few set of reports in RS 2000 based on AS 2000, so I've figured
> out the limitations there. I just want to know if there are any
> problems developing reports in the 2005 designer against a 200
> datasource.
> Sincerely,
> Kaisa M. Lindahl
>

Can I reserve all the rows in Fact table when add the dimension in cube

My fact table join with a dimension table with a foreign key.
But there some foreign key in the fact table which doesn't exist in the
dimension table.
When I add the dimension in cube, all no match rows will be filtered out
Can I reserve all the rows in Fact table when add the dimension in cube?
I'd suggest that as a part of your data load you establish a process which
selects all the foreign keys from fact table that are not found in the
dimension and add them to the datasource for dimension (it can be a table or
a view). Then your dimension and cube will be consistent
Regards,
Ilona Shulman
Senior Development Consultant, DBA
SSE Inc
http://www.sseinc.com
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:elh4y1lqEHA.1728@.TK2MSFTNGP10.phx.gbl...
> My fact table join with a dimension table with a foreign key.
> But there some foreign key in the fact table which doesn't exist in the
> dimension table.
> When I add the dimension in cube, all no match rows will be filtered out
> Can I reserve all the rows in Fact table when add the dimension in cube?
>
|||Analysis Services dislike bad data quality.
so you have to insure that all your keys in your fact table exists in your
dimension.
Generally we create an "unknown" member in the dimension.
For example, the key "-1" is the unknown dimension member.
Then every row in the fact table as the -1 as the default value, so if the
dimension member doesn't exists, your fact table contain -1 and can be used
in the cube.
Change your ETL process to do this job.
"ad" <ad@.wfes.tcc.edu.tw> a crit dans le message de news:
elh4y1lqEHA.1728@.TK2MSFTNGP10.phx.gbl...
> My fact table join with a dimension table with a foreign key.
> But there some foreign key in the fact table which doesn't exist in the
> dimension table.
> When I add the dimension in cube, all no match rows will be filtered out
> Can I reserve all the rows in Fact table when add the dimension in cube?
>

can i process cube from outside analysis manager

I need to process a cube, but i want to do it using c#.. is there any way? Or any example with anyoneThere are a number of ways to process a cube from outside the manager, two come to mind:
1) Use the process cube task in Integration Services.
2) Write a .net program that does it using Analysis Managment Objects (replacement for 2000's DSO objects).

For more options and documentation visit: http://msdn2.microsoft.com/en-us/library/ms243781