ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Measure: count
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

arcticeye

Armenia
14 Posts

Posted - 05/26/2011 :  16:22:19  Show Profile  Reply with Quote
Hello everybody,

I would like to know how to create a new measure that let me count elements, IE: i want to know how many clients has a particular salesman. Is this a measure that I have to create from the very beginning in the SSIS in the fact table? or is it quite simple to add in the SSAS or cube?
Thank you very much.

Best regards,
Matias

--
Matias.

admin

1643 Posts

Posted - 05/26/2011 :  21:40:51  Show Profile  Reply with Quote
You can create a calculated measure in SSAS or ReportPortal using a combination of Count Filter MDX functions.

http://sqlblog.com/blogs/mosha/archive/2007/11/22/optimizing-count-filter-expressions-in-mdx.aspx
Go to Top of Page

arcticeye

Armenia
14 Posts

Posted - 05/27/2011 :  12:16:33  Show Profile  Reply with Quote
Thank you Admin, I just wanto to do some DISTINCT COUNTS in my Reports but I'm trying to figure out how to do it from the SSAS.
Another thing, would you or anyone elke please let me know how to change the the font in the internet explorer? When I open some reports like chart trees in report the x and y legend font size is too small that i cannot read it and this is not I guess a report portal issue. Where can i change that parameter?
Thanks a lot!
Matias

--
Matias.
Go to Top of Page

admin

1643 Posts

Posted - 05/31/2011 :  15:20:28  Show Profile  Reply with Quote
You can see a list of articles about SSAS Distinct Count here:
http://ssas-wiki.com/w/Articles#Distinct_Count

In Internet Explorer you can increase the text size by going to Menu Bar > View > Text Size

In ReportPortal you can modify and create new Themes by going to Admin > Themes and Styles. .Link class, for example will affect the report tree.

It is not recommended but you can also modify the CSS manually. For example, you can control the size of the y labels by modifying bt class in "C:\inetpub\wwwroot\ReportPortal\BarTree\Style.css" file.
Go to Top of Page

arcticeye

Armenia
14 Posts

Posted - 07/07/2011 :  12:51:55  Show Profile  Reply with Quote
Thank you very much for the information. It was very useful!!

--
Matias.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page