Erik Veerman

Blog Archive

►

2008

►

July

► Virtual Conference and other happenings...

►

2007

►

October

► Maximizing Attribute Relationship Aggregations in Changing Dimensions

►

July

► SSAS Many to Many Optimization Technique #2 (using partitions)

►

April

► Old blog entries

►

March

► SSAS Many to many optimization technique #1

About this blog

Your Name

View in Web Browser

/Erik/_layouts/VisioWebAccess/VisioWebAccess.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1

0x0

0x1

FileType

vdw

255

Manage Subscriptions

/_layouts/images/ReportServer/Manage_Subscription.gif

/Erik/_layouts/ReportServer/ManageSubscriptions.aspx?list={ListId}&ID={ItemId}

0x80

0x0

FileType

rdl

350

Manage Data Sources

/Erik/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

rdl

351

Manage Shared Datasets

/Erik/_layouts/ReportServer/DatasetList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

rdl

352

Manage Parameters

/Erik/_layouts/ReportServer/ParameterList.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

353

Manage Processing Options

/Erik/_layouts/ReportServer/ReportExecution.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

354

Manage Cache Refresh Plans

/Erik/_layouts/ReportServer/CacheRefreshPlanList.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

355

View Report History

/Erik/_layouts/ReportServer/ReportHistory.aspx?list={ListId}&ID={ItemId}

0x0

0x40

FileType

rdl

356

View Dependent Items

/Erik/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsds

350

Edit Data Source Definition

/Erik/_layouts/ReportServer/SharedDataSource.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsds

351

View Dependent Items

/Erik/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

smdl

350

Manage Clickthrough Reports

/Erik/_layouts/ReportServer/ModelClickThrough.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

smdl

352

Manage Model Item Security

/Erik/_layouts/ReportServer/ModelItemSecurity.aspx?list={ListId}&ID={ItemId}

0x0

0x2000000

FileType

smdl

353

Regenerate Model

/Erik/_layouts/ReportServer/GenerateModel.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

smdl

354

Manage Data Sources

/Erik/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

smdl

351

Load in Report Builder

/Erik/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderModelContext&list={ListId}&ID={ItemId}

0x0

0x2

FileType

smdl

250

Edit in Report Builder

/_layouts/images/ReportServer/EditReport.gif

/Erik/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderReportContext&list={ListId}&ID={ItemId}

0x0

0x4

FileType

rdl

250

Edit in Report Builder

/Erik/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderDatasetContext&list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsd

250

Manage Caching Options

/Erik/_layouts/ReportServer/DatasetCachingOptions.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsd

350

Manage Cache Refresh Plans

/Erik/_layouts/ReportServer/CacheRefreshPlanList.aspx?list={ListId}&ID={ItemId}&IsDataset=true

0x0

0x4

FileType

rsd

351

Manage Data Sources

/Erik/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}

0x0

0x20

FileType

rsd

352

View Dependent Items

/Erik/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}

0x0

0x4

FileType

rsd

353

Edit in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1&Edit=1

0x0

0x25

FileType

xlsx

256

Edit in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1&Edit=1

0x0

0x25

FileType

xlsm

256

Edit in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1&Edit=1

0x0

0x25

FileType

xlsb

256

Edit in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=EditView&PresentationId={ItemUrl}&source={Source}

0x0

0x4

FileType

pptx

256

Edit in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=EditView&PresentationId={ItemUrl}&source={Source}

0x0

0x4

FileType

ppsx

256

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

docx

255

Edit in Browser

{SiteUrl}/_layouts/WordEditor.aspx?id={ItemUrl}&source={Source}

0x0

0x4

FileType

docx

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

doc

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

dotx

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

dot

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

dotm

255

View in Browser

{SiteUrl}/_layouts/WordViewer.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

docm

255

Edit in Browser

{SiteUrl}/_layouts/WordEditor.aspx?id={ItemUrl}&source={Source}

0x0

0x1

FileType

docm

255

View in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=0&source={Source}

0x0

0x1

FileType

one

255

Edit in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=1&source={Source}

0x0

0x4

FileType

one

255

View in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=0&source={Source}

0x0

0x1

ProgId

OneNote.Notebook

252

Edit in Browser

{SiteUrl}/_layouts/OneNote.aspx?id={ItemUrl}&Edit=1&source={Source}

0x0

0x4

ProgId

OneNote.Notebook

254

Compliance Details

javascript:commonShowModalDialog('{SiteUrl}/_layouts/itemexpiration.aspx?ID={ItemId}&List={ListId}', 'center:1;dialogHeight:500px;dialogWidth:500px;resizable:yes;status:no;location:no;menubar:no;help:no', function GotoPageAfterClose(pageid){if(pageid == 'hold') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/hold.aspx?ID={ItemId}&List={ListId}'); return false;} if(pageid == 'audit') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/Reporting.aspx?Category=Auditing&backtype=item&ID={ItemId}&List={ListId}'); return false;} if(pageid == 'config') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/expirationconfig.aspx?ID={ItemId}&List={ListId}'); return false;}}, null); return false;

0x0

0x1

ContentType

0x01

898

Edit in Browser

/_layouts/images/icxddoc.gif

/Erik/_layouts/formserver.aspx?XsnLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

FileType

xsn

255

Edit in Browser

/_layouts/images/icxddoc.gif

/Erik/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document

255

Edit in Browser

/_layouts/images/icxddoc.gif

/Erik/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.2

255

Edit in Browser

/_layouts/images/icxddoc.gif

/Erik/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.3

255

Edit in Browser

/_layouts/images/icxddoc.gif

/Erik/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.4

255

View in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsx

255

View in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsm

255

View in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsb

255

View in Browser

/Erik/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

ods

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pptx

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

ppt

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pptm

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

ppsx

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

ppsm

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pps

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

potx

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

potm

255

View in Browser

/Erik/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&PresentationId={ItemUrl}&source={Source}

0x0

0x1

FileType

pot

255

Document Set Version History

javascript:SP.UI.ModalDialog.ShowPopupDialog('{SiteUrl}/_layouts/DocSetVersions.aspx?List={ListId}&ID={ItemId}')

0x0

ContentType

0x0120D520

330

Send To other location

javascript:GoToPage('{SiteUrl}/_layouts/docsetsend.aspx?List={ListId}&ID={ItemId}')

0x0

ContentType

0x0120D520

350

Virtual Conference and other happenings...

3 years ago by Erik Veerman

Here's a quick update on happenings! I have some great things coming down the pipe for me and also its been a busy 12 months! But yes, blogging hasn't been my forte, but it's not for a lack of interest. ...

Maximizing Attribute Relationship Aggregations in Changing Dimensions

4 years ago by Erik Veerman

I wrote an article for the Solid Quality Newsletter on understanding the impact of dimension changes on Analysis Services Attribute Relationships...

Read the full article here!

http://www.solidq.com/na/TechArticleDetail.aspx?Id=11

...

SSAS Many to Many Optimization Technique #2 (using partitions)

4 years ago by Erik Veerman

Yep, I am finally getting around to posting my *second* idea on optimizing many-to-many relationships. Really, its more than an idea as I have used the technique successfully on a couple client projects.

...

Old blog entries

5 years ago by Erik Veerman

I have yet to move my old blog entries over to our new blog site... but you can find them here:

http://www.solidqualitylearning.com/Blogs/erik/

Erik Veerman

...on practical SSIS (and SSAS)

erik (at)...

SSAS Many to many optimization technique #1

5 years ago by Erik Veerman

This has been something brewing for a few weeks that I am just getting to writing down… and yes, naming this idea #1 does imply that I have another idea :) so stay tuned. Before diving into the details,...