.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

Call Statement in SSAS calculation

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
 

Hi Experts,

 Any one pls tel me how to use the following statement in SSAS calculations

call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
    ,"Exec DecryptPANKey 1")

 

While i use the above statement in SSAS calculated member it is showing error as

"MdxScript(Dax Data Mart) (8, 5) Parser: The syntax for 'call' is incorrect."

Or tell me how to use the above statement in SSAS Calculations or in Named query

Pls help me to solve the issue.

 

Thanks,

Abdul2010




View Complete Post


More Related Resource Links

How to create call statement as object in SSAS

  

Hi Experts,

                 Any one please tell me how to create as object or attribute for the below Call statement.

Otherwise please guide me how to use the below statement in SSAS.


call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=DWHSRV01;Integrated Security=SSPI;Initial Catalog=Banking"
    ,"Exec Key 1")

 

Thanks,

Abdul2010


Enhance SSAS so that a calculation returns multiple cells at once (Excel fill not a single cell but

  
I wonder if somebody can help me with the following question. I would like to create an enhancement to SSAS in a way so that one can pass in multiple values, run a calculation and in return retrieves not one but multiple cell results at the same time e.g. retSet = functionABC(inSET) where inSet is somthing like 5 4 3 6 7 3 4 4 AND retSet is 4 6 7 8 9 3 4 4 All my calculated members in MDX return a single value BUT I need to have a calculation that if called returns multiple results (a set) at once and in a way so that Excel will properly pick up on it and consequently fills multiple cells in the Pivot table. Is that possible at all and if so how? I would not mind to write a little CLR assembly to enhance the SSAS but don't know how to pass the results back. Any ideas are highly appreciated. Dirk

Some functions are missing in SSAS calculation tool for my sql 2008 R2 installation (DAX functions?)

  
In relation to this post: http://connect.microsoft.com/SQLServer/feedback/details/569767/some-functions-e-g-timedate-are-blank-under-the-calculation-toolbar-others-are-ok  I understand that the AS functions are loaded from a XML schema, could a quick solution from Microsoft be to send an updated xml file? When I expand the "All" group under Functions the first 120 MDX (or DAX) functions are blank. I understand that this only a SQL Server 2008 R2 problem and that it's perhaps the DAX functions that shows up blank. // Bjorn

SSAS - calculation of ssrs report should be calculated before calculation in MDX script

  
Hi All I have: - A calculated member defined in an mdx query of an SSRS report (using the aggregate function). - A calculated member defined in the MDX Script of the cube The calculated member of the cube calculates a ratio. What we should achieve is the ratio of the aggregated members (defined in the report) and not the aggregation of the ratios. I thought that it would be automatically enforced by: http://msdn.microsoft.com/en-us/library/ms145539.aspx :"The exception to this precedence is the Aggregate function. Calculated members with the Aggregate function have a lower solve order than any intersecting calculated measure." I tried to play with the solve_order of the two calculated members (defining explicitly a lower solve_order for the aggregation defined in the report), but the calculation of the cubes is always executed first => I end up with the aggregation of the ratios. Are calculations defined in the MDX script always executed first? This doesn't seem logical to me.. Thanks a lot for your help. Regards Stefan    

Cannot call Table Valued Function from Dynamic stored procedure statement

  
Hello,  I have a table-valued function that splits string into a table column. I can easily call this function from a stored procedure within a regular SELECT statement: SELECT * FROM Table1 WHERE Code1 = '1' AND Code2 IN(SELECT * FROM [dbo].[fnSplitValues](@Code2String))   However when I try to use the same logic for a dynamic SELECT statement: ‘SELECT * FROM Table1 WHERE Code1 = '1' AND Code2 IN(SELECT * FROM ' + [dbo].[fnSplitValues](@Code2String) + ')’ I get an error ‘Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnSplitValues", or the name is ambiguous.’ Any idea what is wrong with my dynamic SQL?   Please help, Lana

How to call assembly in SSAS

  
Hi,   Any pls tell me how to call assembly in SSAS.   i want steps to call the assembly I want to write decryption logic in assembly. Then i want to call the assembly in SSAS. Please any one help to solve the issue. Thanks, Abdul2010    

How to intercept an Excel PivotTable call result from an SSAS cube?

  

We have a SSAS Cube (2008 R2) on a server, which end-users are viewing with Excel 2010’s PivotTable interface.

We now want to stop end-users dynamically from drilling down to sensitive data.

Specifically, we want to dynamically block the return of any pivot table in which any element has a count of less than k  (and ideally: an error to be displayed ‘query results would return sensitive data – please modify your query’)

This feature should be implemented on the server-side cube not at the level individual end-user's Excel (e.g., Excel add-in).

 


SUM(Root()) in SSAS calculation

  

Hi..

Am trying to add a calculation member inside the Cube (BIDS) but am not getting the results I need...
I need to show the percentage of one measure depending on the dimension. So, the total is 100% and then inside each row has to show less than 100%, split it by dimension attributes.

What I have right now is:
[Measures].[Call Volume] / Sum(Root(Measures), [Measures].[Call Volume] )

But is not showing anything....

I will appreciate all the information you can give me...

Thanks!

 

 


SSAS 2008 - Occupancy Calculation Cube?

  

Hi there,

Previously I posted my probelm into T-SQL forum section. Here is link http://social.msdn.microsoft.com/Forums/en/transactsql/thread/b02d37b4-d36e-42cc-b1f4-3c00abadfdd4

I have SQL 2005 table like

Room      AdmissionDate    DischargeDate
R1             2010-01-25           2010-01-28
R1             2010-01-28           2010-01-30
R1             2010-02-15           2010-02-17
R1             2001-02-20           NULL         
R2             2010-01-31           2010-01-31
R2             2010-02-10 

Giving syntax error for CASE statement using VS (SSAS) 2008 designer

  

Hi All,

I am writing following CASE statement in Data Source View-> Righ click measure table "xyz" -> and select "Edit Named Query"

SELECT

C

 

.COMMITMENT_TYPE_SKEY,

case WHEN(CT.COMMITMENT_TYPE_FLAG = 'P') THEN C.AMOUNT_USD ELSE 0 END AS REQUISITION_AMT,

case WHEN(CT.COMMITMENT_TYPE_FLAG = 'C') THEN C.AMOUNT_USD ELSE 0 END AS OBLIGATION_AMT

FROM

SET statement in named calculation

  

Hi,

I'm trying to include the following query in the DSV, as a named calcluation or through named query. But both the options are not working.

SET DATEFIRST 1

DATEPART

 

(ww,calendardttm) + 1

<

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Using jQuery to directly call ASP.NET AJAX page methods

  
Here I am looking to explain how to call page methods using jQuery. Using jQuery to directly call ASP.NET AJAX page methods

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

AGE CALCULATION IN YEARS AND MONTHS

  
How to calculate childs age,but when i enter childs age as '03/27/2007' it returns 3 years where as actual age is 2 yr 11 months

How to call an .exe file in .net

  
Sometimes a developer has to call an EXE from another EXE. While calling EXE there can be a requirement to pass parameter.

calculation, field and map traverse adjustment, and coordinate transformation

  
Free Pocket PC land surveying software -- COGO calculation, field and map traverse adjustment, and coordinate transformation -- for students and professionals.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend