| T O P I C R E V I E W |
| arcticeye |
Posted - 05/26/2011 : 16:22:19
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. |
| 4 L A T E S T R E P L I E S (Newest First) |
| arcticeye |
Posted - 07/07/2011 : 12:51:55
Thank you very much for the information. It was very useful!!
--
Matias. |
| admin |
Posted - 05/31/2011 : 15:20:28
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.
|
| arcticeye |
Posted - 05/27/2011 : 12:16:33
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. |
| admin |
Posted - 05/26/2011 : 21:40:51
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
|
Report Portal
