Ella Maschiach's BI Blog - All Comments

analysis services – denying access to a specific dimension a | Excel Tips | Word Tutorials

Wed, 22 May 2013 14:47:53 GMT

Pingback from analysis services – denying access to a specific dimension a | Excel Tips | Word Tutorials

re: Access and Visio Services and Spatial Data in SharePoint 2010

Appel — Wed, 22 May 2013 14:17:25 GMT

It's a pity you don't have a donate button!

I'd certainly donate to this brilliant blog! I suppose for now i'll settle for bookmarking and

adding your RSS feed to my Google account. I look forward

to fresh updates and will share this blog with my Facebook group.

Chat soon!

re: Slowly Changing Dimension type 2 in SSAS

Guest — Wed, 10 Apr 2013 12:39:54 GMT

This simply does not work, the Adventureworks Product and Employee connect using the surrogate key.

There something special in the dimensin usage.

The Scd Types are for description only, they do nothing is SSAS.

This approach does not work!

re: The pros and cons of Report Builder 3.0 over Report Builder 1.0

Ella Maschiach — Wed, 19 Dec 2012 13:57:26 GMT

Hi Bini,

Using a query like:

select reportid, Path, Name, Parameter

FROM [ReportServer].[dbo].[ExecutionLogStorage] e

inner join [ReportServer].[dbo].Catalog c

on e.reportid = c.itemid

You can see which user ran the report and with what values for each parameter. This is also true for RB and not just RS reports. This is also provided that you run the reports with your users credentials and not through a general user for an application.

All the best,

Ella

re: Visual Totals in MDX and Role Security

Ella Maschiach — Wed, 05 Dec 2012 13:10:27 GMT

Sebastian,

1. Default member may give you a default total (for that specific member) to return to your user, but it doesn't block your user from choosing a different member and seeing the sum for that. It does not limit your user.

Visual totals, on the other hand, enables your user to see just the sum for the selected members. It limits the user and upholds security.

2. You can check mark all the members you'd like the user to see and leave the visual totals unchecked so he can still see the sum for the entire dimension.

Boris,

I felt like you answered Nancy more than asked a question.

All the best,

Ella

re: Visual Totals in MDX and Role Security

Ella Maschiach — Tue, 04 Dec 2012 07:59:19 GMT

To Boris and Sebastian, I apologize but by mistake I ended up deleting your comment as you were classified as spam by the site. I re - published them under my name and will comment later.

re: Visual Totals in MDX and Role Security

Ella Maschiach — Tue, 04 Dec 2012 07:50:32 GMT

Hey together,

okay let´s again start from the above.

I´d like to understand the difference between 'enable visual totals' and 'Default Member' when set to the element of the alowed set.

As you also posted here it might not be useful to the the totals when your rights are constricted to a certain alowed set. the problem is not only the totals but the fact that you are able to see the elements from other Dimenisions (e.g. when you have two dimensions 'company' and a dimension that represents the 'fact table' containing the company also; and you have an alowed set giving you the right on the dimension 'company' to see a specific company only, you are still able to see the data of other companies through other dimensions.)

if you set the 'enable visual totals' flag all dimensions respect the settings done in the dimension 'company'. that´s what I expected the 'default member' to control. in fact this is doing the same.

1. What is the difference?

2. What if you want to define the user to see only allowed elements no matter from what dimension - but at the same time to see totals over all the dimension´s members?

re: What's New in SQL Server Integration Services 11 CTP1

Kayla — Fri, 26 Oct 2012 03:36:53 GMT

I believe that SSIS has eolevvd to a point where it can handle multiple and complex transformation in memory. ETL packages shall be database agnostic and should minimize the need for adding any special procedure or feature to the source, other than granting proper rights to read it. This makes the packages transportable and easy to migrate from 1 SSIS server to another, as well as easy to let the datasource migrate from one place to another.Now, in certain conditions where the data extracted requires several tables joined, and the output is for several million rows, the sort operation can benefit from the database engine as it is optimized to deal with such a task in the most efficient way.So I agree that it depends. But I tend to have as much as possible on the SSIS side as the database is not designed to perform any transformation in an efficient way. The RDBMs engine is optimize to store and retrieve data and keep it in a very relaible state.

re: The Many to Many Relationship

MOrpheus — Fri, 19 Oct 2012 16:42:17 GMT

Thanks Ella,

Your blog helped me understand this.

One step on RDBMS and another on the Cube sort of a hybrid solution.

Although this would only come up when we have facts present for each lookup.

Cannot do a left outer type join from Many-To-Many to the fact since not all data will be mapped...

Had to write a SQL join to get the data where the Many-To-Many had no facts.

But still works for me.

Thanks ! People Happy

re: Recursive Sum for a Group in a Matrix in SSRS

sarvam — Thu, 04 Oct 2012 17:23:39 GMT

how to do the average of average in a matrix .

re: SQL Server 2012 Licensing Reviews and Views

Chang — Thu, 27 Sep 2012 04:47:53 GMT

The SQL standard names are LOWER and UPPER, not LCASE and UCASE. Some pcudorts like MySQL alias LCASE and UCASE to the LOWER and UPPER functions for increased compatibility with other non-standard pcudorts and some pcudorts that are not databases. MS Access uses LCASE and UCASE as does the non-database pcudorts Excel and OOCalc. There are some programming languages which use LCASE and UCASE. There may be other DB pcudorts that do not use the SQL standard LOWER/UPPER names for these functions. Oracle does use LOWER/UPPER. DB2 supports both. PostgreSQL uses LOWER/UPPER.

re: The pros and cons of Report Builder 3.0 over Report Builder 1.0

Ella Maschiach — Sun, 02 Sep 2012 19:58:35 GMT

Hi Michael,

I can't say that I've used Report Builder integrated with SharePoint, but I have updated an entire RB 1.0 project (data source and model) and it hasn't changed a thing in the reports. So you can update both without a worry I believe.

re: The pros and cons of Report Builder 3.0 over Report Builder 1.0

Michael Berry — Thu, 30 Aug 2012 21:36:38 GMT

quick question... I would like to know what to expect if I upgrade the data source for the report model. will I have to upgrade the report model? The report model and reports are currently on a sharepoint 2010 running integrated mode.

re: The pros and cons of Report Builder 3.0 over Report Builder 1.0

Ella Maschiach — Thu, 30 Aug 2012 20:10:08 GMT

glad I could help :)

re: The pros and cons of Report Builder 3.0 over Report Builder 1.0

mike berry — Thu, 30 Aug 2012 19:12:11 GMT

This is very helpful. Thank you for making this post. I have a user that refuses to upgrade and we are upgrading their data source to 2008 and assumed, incorrectly that they would have no choice but to upgrade. thanks for the very informative posts!