14
Oct

כמה הערות על "מכונת האמת המוחלטת"

בעתון דה מרקר הופיעה אתמול כתבה שכותרתה:הסטארט-אפיסט שבונה את מכונת האמת המוחלטת: "זדורוב חף מפשע".מדובר בראיון עם הסטאראפיסט המצליח סער וילף. לאחר מספר שאלות מתבקשות על הצלחותיו עד כה, איך עשה את כספו, וכדומה, מגיעים לחלק המעניין, בו הוא מספר על הסטארטאפ הנוכחי שלו, ותוך כדי כך הוא מביע את דעתו על מערכת המשפט שלנו. […] Read More
13
Oct

A preliminary analysis of the Nobel Laureates

Every year in early October, the eyes of the world turn to Sweden and Norway, where the Nobel Prize winners are announced to the world. The Nobel Prize is considered the world's most prestigious award. Since 1901, the Prize has been presented to individuals and organizations that have made significant [...]

A preliminary analysis of the Nobel Laureates was published on SAS Users.

Read More
12
Oct

Advanced ODS Graphics: Two types of axis tables

Axis tables can use the SUM= option to summarize data and display means, medians, sums, and percentages. They can instead be used to display data, text, and statistics without any summarization. The post Advanced ODS Graphics: Two types of axis tables... Read More
12
Oct

Cisco Information Server (CIS) and MS OLAP

Ok, so my recent issue was integrating CIS with Microsoft OLAP cubes. The normal way to do this is to set up MS OLAP (SSAS) with a website and use XML/A to connect. I started down that path and decided to try a different tack based some StackOverflow articles. Here is my approach that worked great:


The trick here is to use a Linked Server in the middle of the connection. For this, you need a SQL Server
instance.


Steps



Open SSMS. Create a new query










In a SQL Server instance, set up a Linked Server. Here is an example:

EXEC sp_dropserver 'TEST_OLAP'
EXEC master.dbo.sp_addlinkedserver
@server='TEST_OLAP',
@srvproduct='MSOLAP',
@provider='MSOLAP',
@datasrc='APSEPXXXX',
@catalog='Commitments'




EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname='TEST_OLAP',
@useself='False',
@locallogin=NULL,
@rmtuser='MSXXXXX',
@rmtpassword='***********'
GO

• Create a query to go against the Linked Server and pass the MDX query:
select
"[Policy].[Master Policy].[Master Policy].[MEMBER_CAPTION]" AS MasterPolicy,
"[Due Date].[Calendar].[Year].[MEMBER_CAPTION]" AS Year,
"[Due Date].[Calendar].[Quarter Name].[MEMBER_CAPTION]" AS Quarter,
"[Due Date].[Calendar].[Month Name].[MEMBER_CAPTION]" AS Month,
"[Policy].[Policy Number].[Policy Number].[MEMBER_CAPTION]" AS Policy,
"[Measures].[Commitments Closed Within TAT]" As CommitmentsClosedWithinTAT
from openquery
(
'TEST_OLAP,
'SELECT NON EMPTY { [Measures].[Commitments Closed Within TAT] } ON COLUMNS, NON EMPTY
{ ([Policy].[Master Policy].[Master Policy].ALLMEMBERS *
[Due Date].[Calendar].[Month Name].ALLMEMBERS *
[Policy].[Policy Number].[Policy Number].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( { [Due Date].[Calendar].[Year].&[2015] } ) ON COLUMNS FROM [Commitments
Advocate4Me])'
)


• NOTE: If you need to determine the odd MDX variables coming back, run this query:
select * INTO #TEMP_A4M from openquery
(
'TEST_OLAP,
'SELECT NON EMPTY { [Measures].[Commitments Closed Within TAT] } ON COLUMNS, NON EMPTY
{ ([Policy].[Master Policy].[Master Policy].ALLMEMBERS *
[Due Date].[Calendar].[Month Name].ALLMEMBERS *
[Policy].[Policy Number].[Policy Number].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( { [Due Date].[Calendar].[Year].&[2015] } ) ON COLUMNS FROM [Commitments
Advocate4Me])'
)


select * from tempdb.sys.columns where object_id =object_id('tempdb..##TEMP_A4M');


  1. Set up your SQL Server Data Source
• Put it into Packaged Query and do Design by Exampl

Read More
12
Oct

PROC FORMAT Error with CNTLIN

What I was doing:Using a SQL Server table to feed a PROC FORMAT using CNTLIN.Error message seen:ERROR: Cannot mix missing and nonmissing values in the same rangeCause:START column was defined as character and END column was defined as a numeric (decimal) Read More
11
Oct

Transforming Analytics into an Art Form

As analytics advances into more areas of our everyday life there is an increased need to understand just what it is that analytics is accomplishing for us.  I find there is a quicker acceptance of an analytical solution and even excitement if there is a good conceptual understanding of what [...]

The post Transforming Analytics into an Art Form appeared first on SAS Learning Post.

Read More
11
Oct

Improving data quality through SAS Data Remediation

With SAS Data Management, you can setup SAS Data Remediation to manage and correct data issues. SAS Data Remediation allows user- or role-based access to data exceptions. When a data issue is discovered it can be sent automatically or manually to a remediation queue where it can be corrected by [...]

Improving data quality through SAS Data Remediation was published on SAS Users.

Read More
11
Oct

Scottish Festivals and Highland Games

I recently took a trip to Scotland, to attended the Highland Games! (ok - that statement might be a tiny bit misleading) It was a very cool and interesting event, and I wondered where and when other such events might be happening. What better way to an... Read More
11
Oct

Simulate correlations by using the Wishart distribution

The article "Fisher's transformation of the correlation coefficient" featured a Monte Carlo simulation that generated sample correlations from bivariate normal data. The simulation used three steps: Simulate B samples of size N from a bivariate normal distribution with correlation ρ. Use PROC CORR to compute the sample correlation matrix for [...]

The post Simulate correlations by using the Wishart distribution appeared first on The DO Loop.

Read More
10
Oct

Reading and writing GZIP files with SAS

SAS 9.4 Maintenance 5 includes new support for reading and writing GZIP files directly. GZIP files, usually found with a .gz file extension, are a different format than ZIP files. Although both are forms of compressed files, a GZIP file is usually a compressed copy of a single file, whereas [...]

The post Reading and writing GZIP files with SAS appeared first on The SAS Dummy.

Read More
Back to Top