Procedure Time out: proclarity

Showing posts with label proclarity. Show all posts

Friday, March 23, 2012

ProClarity: Is there any way we can use tables as sources of ProClarity views instead of cubes?

Is there any way we can use tables as sources of ProClarity views instead of cubes?

Hello! It is not possible. ProClarity is a SSAS-tool only.

You must build a cube in order to use ProClarity.

HTH

Thomas Ivarsson

sql

ProClarity Slicersel parameters

Hi,

I am using ProClarity 6.1 and Enterprise version of analysis server 2005. (not sure if I need an proclarity update or a fix for ProClarity because i guess there is a newer version 6.2)

Because of one of the performance optimizations that I did after following some blogs on the net, I can't specify slicerSel parameters to my proclarity graphs! Let me explain:

I have a slicer in Proclarity graph for which I used to specify a url querystring parameter as slicerSel=xxxxxx. This was working until I modified the dimension.

The modification: initially my dimension had the following attributes: Key, Name. Now I just have one attribute Name, whose key column points to KEY (db) and Name column points to NAME (db). because of this my slicerSel parameters do not work.

I checked the html of proclarity by doing an view souce and found the following difference.

before:

<option value ="[CLIENTNAME].[NAME].&[ABCDE FGHIJK]">ABCDE FGHIJK<option>

After modifing the Keycolumn and Namecolumn:

<option value ="[CLIENTNAME].[NAME].&[4.94735E6]">ABCDE FGHIJK</option>

Now I can't specify the slicer using the number 4.94735E6 which i dont think is the key (its in scientific format).

My question is, Is there any way out to specify the slicer as ABCDE FGHIJK (Name) as before ?

If it is not possible, shall I add another attribute to the dimension called Key and then seperate the Key and Name from the single attribute? will this impact the performance? especially because the dimension will have another attribute which contains just the key, which will not be displayed but used in the relationships. Is there any specific way to design this? (Key is the primary key column of the database table, which is used for storing dimension values and referenced in the Fact tables).

Regards

Your key is 494735.

The only way you will get the name there is to set-up the name only as a separate attribute. Then the name will be used as a key, slightly less efficient. ProClarity generates the MDX with the key element of the attribute value that is selected from the slicer.

You can also change the data type of the key when creating the attributes in Visual Studio. Sometimes it defaults to a double if the data is sourced from a view rather than a table.

Proclarity reports

Hi, all

Thank you very much for your kind attention.

I encountered a problem with Export ProClarity reports. The problem is: under the 'Export' option, there is not 'Export to business reporter'. Other options like: 'Export to reporting service', 'Export to PowerPoint', 'Export to outlook' are available.

Can someone please tell me what the issue is.

Thanks in advance,

Mita

This is an separate option on the install page for ProClarity Professional. Have a look at the startpage when you install professional.

HTH

Thomas Ivarsson

proclarity question

Hi,

I have a question regarding Proclarity viewer and whether it can assists me.

I have a UDM as follows.

A fact table containing a sale for each salesman. There can be more that one row per salesman

This Fact is connected to a dimension dim_salesman that hold details about each salesman and other more dimensions.

Another fact containing a number of vacations each salesman took. There is more that one row per salesman.

This fact also connected to the same dim_salesman and and other more dimensions.

I want to inquire for example - how many vacations and sales each saleman had, sliced by the dim_saleman.

If I uses a pivot table excel to view a report that contains data from both fact tables I get wrong data.

Is the proclarity viewer able to browse 2 different fact tables and join them to a single report?

Thank for you help.

Hello. Both ProClarity Professional 6.2 and Excel 2007 can create reports from data in two separate fact tables.

This is not as much a client question but how you have related the two measure groups(fact tables) in the cube editors dimension usages tab. In SSAS2005 one cube can have several fact tables(measure group).

HTH

Thomas Ivarsson

Proclarity Installation using SQL Server 2005

Hi,

I'm attempting to install Proclarity 6 on a Win2003 Virtual PC, using SQL Server 2005 as my DB platform.

The installation continually fails with the error: "The SQL Serve Selected is not in Mixed Mode...". This occurs even if i specify the 'sa' account during the installation.

My SQL Sever is definitely set to Mixed Mode authentication!

Has anyone come accross this before and is there a fix?

Thanks in advance,

Leigh.

just run this statement and see whether its returning 0 or not

select SERVERPROPERTY('IsIntegratedSecurityOnly')

Madhu

|||

Hi Madhu,

I ran that statement and got 0 back from the server suggesting that i am indeed running in "Mixed Mode".

Cheers,

Leigh

|||

Well, i'm not sure why, but i've applied SQL 2005 SP2 and created a new user which i specified to run the ProClarity installation and hey-presto, suddenly everything works!

Cheers,
Leigh

Proclarity Installation

Hello all. I am having the hardest item installing proclarity on my machines. The installation goes through fine but when I login to the site I do not see an option (should be a drop down) to select web vs pro edition. When I check for downloads, it shows none available. I did install the web professional from the main installation window, and the files are on the drive itself.

On a different note, I have read most of proclarity's documentation, but cannot seem to find how to have web pro (well std until I have the pro option) connect to an existing cube and allow data browsing/drill down, etc. Any link or doc you can point to for this will be very helpful.

Thank you in advance for your help.

Hello. You manage the access to web professional in the administration console for PAS(Analytics Server).

Each role you create there would have to be allowed to download web professional.

ProClarity is currently in a "no mans land" because it is owned by Microsoft and the ProClarity Platform will be part of PerformancePoint.

HTH

Thomas Ivarsson

|||

Thank you for your answer. I was able to solve the mystery and it is just like you said. I just want to clarify the solution a bit more for other folks who may face the same road block.

Fireup the proclarity administration tool, click on users node and for each user/group right click and choose properties. There you can provide permission to access proclarity professional.

sql

ProClarity Expert Needed for our BI Team - Texas Job Opportunity

Hi All,

We are starting on a tool called Proclarity, which is used on top of Microsoft SQL Server Analysis Services. Having this as the basic idea, I’m not clear on some information as listed below: Any clarification would be very helpful.

1 Having SSRS (SQL Server Reporting Service) available to perform reports, what is Proclarity for Reporting Services. What it does by integrating with SSRS and its advantages. How is it different from Proclarity Web/Desktop professional.

2 Having Business Scorecard manager from Microsoft, what is the purpose of Proclarity KPI Designer, its advantages/disadvantages over BSM? Still proclarity has one more add-on Proclarity for BSM (not sure why we need this)

3 Proclarity Selector – Purpose of this tool?

4. Why is that Proclarity Dashboard server? We can create a view of dashboard using Sharepoint. Not sure about the advantage of this.

Regards, Kart

Hello!

1. This is a project that is added to the SSRS designer in BI-DEV studio. It will start up a ProClarity professional interface in Reporting services and also help you with formatting the report.

2. The KPI-designer is a tool for building and saving KPI:s in ProClarity Analytics server. Its main use is to build KPI:s on top of SSAS2005 cubes. Business scorecard manager is a tool for building balanced scorecards. The main difference is that BSM can use weights for KPI:s and also create hierarchies for KPI:s. BSM can do this with more data sources than ProClarity.

3. This tool helps you with building named sets, like the top 10 best selling products.

4. PDS is a dashboard server. Sharepoint can do a little more than that. The main advantage with PDS is that it is easy to create and visualize KPI:s from Analytics server, without having to write MDX.

HTH

Thomas Ivarsson

|||

Hi Thomas,

Thanks for the Info.

1. When you say Proclarity for Reporting Services.is a project used for formatting reports, how it benifits us. We can do formatting in BI studio of SSRS.

2. When you say BSM can create Hierarchies for KPIs, it is like by adding a KPI to scorecard and adding Row Members (in scorecard view). Is my understanding correct. Doesn't this come automatically in proclarify when we define a KPI using a measure - because the we would have defined hierarchies in cube itself.

3. I hope it is added as a add-on (menu item in toolbar) of Proclarity Designer

4. Got it.

Regards, kart

|||

1. The ProClarity designer in SSRS2005 is better than Reporting Services own. It is a matter of taste.

2. This is from memory, but in BSM you create objectives and place one or serveral KPI:s in that objective. This objective is a KPI that is defined by the KPI:s mapped to it. In ProClarity and SSAS2005(the KPI-tab) the KPI:s you define are not presented in hierarchies but flat. Measures do not have hierarchies in SSAS2005.

3. Selector is placed on the toolbar. It is a part of the Business Logic Server if you install that.

Regards

Thomas Ivarsson

|||

Hi Thomas,

Thanks again and I got good clarity on Proclarity now.

2. Can I conclude like -KPI definition through BSM is better than doing the same using Proclarity KPI Designer and Defining KPI in the Cube itself. (But, still go ahed using Proclarity for Detailed analysis of any value that is defined by KPI)

Regards, Kart

|||

Hi,

In my humble opinion, you should not prefer to use BSM KPIs when you plan to use SSAS2005 as target.

BSM KPIs have many advantatges if you need to define KPIs based on ODBC datasources, Excel or just type the values manually.

However, if the source for the KPI data is SSAS, I will define the KPI at SSAS, making it centrally managed and reusable in other places (like SSRS), and import the KPI tp BSM (using the KPIUtil tool).

HTH,

Jordi Rambla

Solid Quality Learning

|||

I found your blog/contact information searching Google.com for BI Consultants with ProClarity expertise. Are you looking for a new opportunity? If so, we would like to consider you for a Senior BI job opportunity. If you are not looking at this time, then I will continue to save your contact information and re-contact you at a later date. We are not a staffing company, we are the employer.

Catapult Systems is a Microsoft Gold Partner with locations in Austin, Dallas, Houston, San Antonio and in Tampa, Florida. We were named the #2 BEST COMPANY TO WORK FOR in Texas by TEXAS MONTHLY Magazine (January 2006) and named the #1 Medium size COMPANY TO WORK for in Austin by the Austin Business Journal for 2005. Please visit our website to learn more about us – www.catapultsystems.com.

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

|||

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

|||

Hello Jordi,

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

ProClarity Desktop Professional 6.3 - Totals Performance

I am using PDP 6.3. When I try to put a total on my grid, it basically kills ProClarity. I know there was a problem with Totals in older versions of PDP, but I thought it would have been fixed by now. Is there some workaround or hotfix?

Thanks,

Linda Fleming

Hello Linda! I have not seen performance issues with ProClarity totals but can you send some more information regarding your problem?

Can you recreate the problem on the Adventure Works sample cube or can you tell us more about the structure of your cube?

Regards

Thomas Ivarsson

|||

Thomas,

(Note: I tried using a partition but did not make any difference because I think the problem is with the large number of dimension rows and not the fact table)

factTable: 200,000 rows.

I want subtotals in my view by Stage, but the query never returns.

All Companies has 1614 rows

All Opportunities has 406 rows

Here is my MDX:

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

NON EMPTY { { { [Stage].[Stage].&[10 - Confirmed], [Stage].[Stage].&[20 - Qualified], [Stage].[Stage].&[30 - Proposed] } * { DESCENDANTS( [Company].[Company].[All Companies], [Company].[Company].[Company] ) } * { DESCENDANTS( [Opportunity].[Opportunity].[All Opportunities], , LEAVES ) } } } ON ROWS

FROM [Daily Pipeline Snapshot]

WHERE ( [Measures].[Opportunity Value], [Sales Rep].[Sales Rep].&[TAYLOR], [Opportunity Status].[Opportunity Status].[Op Status].&[Open], [Probability].[Probability Description].[All Probability] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

I can send you my cube if this would expedite things.

|||

Hello Linda. I think that the problem relates to that you crossjoin several dimensions, one of them at the leaf level.

I do not know how many members you have in each dimensions but if you can do subtotals on the Adventure Works cube it is probably the design of the cube that decides this.

If you remove some dimensions in the crossjoin and only start with the first two? Will it work?

HTH

Thomas Ivarsson

|||

Hi,

There isn't a work around or hotfix for the problem, we had the same problem and users have been banded from including them in their queries.

Most of the time you don't need to use ProClarity's Total options, if you are selecting every child of an attribute, you can just include the all level as well and that will give you a total e.g.

All Opps

-opp1

-opp2

-opp3

SELECT { [Measures].[Measure1] } ON COLUMNS ,
{ [Dim].[Opps].[All Opps], [Dim].[Opps].&[Opp1], [Dim].[Opps].&[Opp2],[Dim].[Opps].&[Opp3] } ON ROWS
FROM [fact]

would give you an all level (total)

Measure

All 20

opp1 5

opp2 5

opp3 10

If you're not using all the members in the attribute, I wouldn't let ProClarity build your MDX statement with totals. It ends up writing the most inefficient code ever, hence why proclarity dies. Perhaps write your own MDX and paste it in the MDX viewer.

HTH

Matt

|||

Good point Mark but if the subtotal feature is usable or useless depends on how many cells that you call with several dimensions on an axis and on the leaf level.

No tool can manage that!

Regards

Thomas Ivarsson

|||

I wasn't really saying it was, I was just impling that ProClarity generates rubbish code. I am sure some careful planning of a report or generating your own MDX is more efficent than using ProClarity's total functions.

I was perhaps offereing a work around for the problem seeing as there wasn't a fix.

Mark AKA Matt

|||

Hello Matt. I will try your solution.

The problem with your approach is that your own MDX will be changed to ProClarity MDX as soon as a user start to change your report. Your solution will probably work well with SSRS2005 or if you publish static ProClarity reports.

I have published several complaints about ProClarity's implementation of MDX on my blog.

Regards

Thomas Ivarsson

|||

Matt,

Thank you for your comments. Our company has been struggling with the Totals for several years and just keep hoping it gets fixed. I notice it uses the Aggregate function. Maybe SUM would be better? I will keep working on it, but Thomas has a good point that you can't start analyzing the view. If it is a static view on the dashboard I suppose custom MDX would work.

Linda

Thomas,

I took off the 3rd dimension (Opportunity) and the subtotals worked. Here is my MDX:

WITH MEMBER [Company].[Company].[All Companies].[ Subtotal]

AS ' AGGREGATE( EXISTING

{ DESCENDANTS( [Company].[Company].[All Companies], [Company].[Company].[Company] ) }) ',

SOLVE_ORDER = 1000

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

NON EMPTY { { { { [Stage].[Stage].&[10 - Confirmed], [Stage].[Stage].&[20 - Qualified], [Stage].[Stage].&[30 - Proposed] } } * { { [Company].[Company].[All Companies].[ Subtotal] }, { DESCENDANTS( [Company].[Company].[All Companies], [Company].[Company].[Company] ) } } } } ON ROWS

FROM [Daily Pipeline Snapshot]

WHERE ( [Measures].[Opportunity Value], [Sales Rep].[Sales Rep].[All Sales Rep], [Opportunity Status].[Opportunity Status].[Op Status].&[Open], [Probability].[Probability Description].[All Probability] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

However, now, I don't know what to try next since I really need that last dimension. Is there a possible solution? I would really like to send you my cube and let you experiment with it. Is that an option?

Linda

|||

Hi,

Still a little confused by what you are both saying, as I can produce something identical to what you are suggesting in ProClarity and still slice and dice it afterwards. So that wouldn't imply it was static.

e,g, You code looks something like:

Code Snippet

WITH MEMBER [Campaign].[Campaign Region].[All Campaigns].[ Subtotal]

' AGGREGATE( EXISTING { [Campaign].[Campaign Region].[All Campaigns].CHILDREN }) ',

SOLVE_ORDER = 1000

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns].CHILDREN },

{ [Campaign].[Campaign Region].[All Campaigns].[ Subtotal] } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

mine looks something like

Code Snippet

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns]},

{ [Campaign].[Campaign Region].[All Campaigns].children } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

They both produce the same results and I can slice it later on. I didn't write the code; I used ProClarity to generate it, so there is no reformatting. Which I know is an issue if you start having drop down slicers or usign subcubes. The performance hit is less as well with mine, on a cold cache the top one ran 13secs lower one 3 secs.

The only difference is I have an "All level" at the top and you have a "sub total" at the bottom.

The only down side to it as far as i can see it is if you don't include all the members of the dimension then the "All level" doesn't work.

And no matter what you code to fix the issue, as soon as you drill into something ProClarity will revert it back to using its way of MDX. So you could have a fancy quick query on the first page but as soon as you drill into a level, you still going to lose your code and perhaps incur a performance hit. Which I found out when I drilled into mine, ProClarity reverted it back to using subtotals.

You could always try caching the results (common ones) that way when your uses run their queries they hit the cache first. I believe chris webb has a blog on cache warming.

Matt

|||

Hello Linda! This one

Code Snippet

{ [Next 3 Months Anticipated Close] }

on columns is that a calculated member, calculated measure, named set or dimension member?

You can send me the cube but the problem is that we cannot change ProClarity's MDX behaviour. Have you tried the same view/query in Excel 2007? I think you can download a trial version only to see if there is a difference between these clients.

Regards

Thomas Ivarsson

|||

Thomas,

[Next 3 Months Anticipated Close] is a named set.

STRTOSET(

"[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0):
[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0).Lead(2)")

Where can I send the cube? I would like you to look at it and see if you get the same behavior I do.

Can Excel 2007 read cubes?

Linda

|||

Linda! Excel2007 supports all SSAS2005 features except writeback. Try that option first and see if it helps.

It can reveal if it is ProClarity's MDX that is the problem.

How large is the cube? If it is large you may have to place it on an FTP-site.

If you look at my profile you can see my email.

STRTOSET is not good for performance. Is that a dynamic,running month, set?

Regards

Thomas Ivarsson

Regards

Thomas Ivarsson

|||

Thomas,

We have Excel2007. I will install it and try it.

The data warehouse is 10,500 KB.

Yes, it is a dynamic running month set. What can I use instead of STRTOSET?

Thanks,

Linda

|||Linda! I have an example here: http://thomasianalytics.spaces.live.com/blog/cns!B6B6A40B93AE1393!352.entry

There are many other ways to solve this.

I think you can send the cube directly.

Regards

Thomas Ivarsson

ProClarity Desktop Professional 6.3 - Totals Performance

Thanks,

Linda Fleming

Hello Linda! I have not seen performance issues with ProClarity totals but can you send some more information regarding your problem?

Can you recreate the problem on the Adventure Works sample cube or can you tell us more about the structure of your cube?

Regards

Thomas Ivarsson

|||

Thomas,

(Note: I tried using a partition but did not make any difference because I think the problem is with the large number of dimension rows and not the fact table)

factTable: 200,000 rows.

I want subtotals in my view by Stage, but the query never returns.

All Companies has 1614 rows

All Opportunities has 406 rows

Here is my MDX:

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

FROM [Daily Pipeline Snapshot]

WHERE ( [Measures].[Opportunity Value], [Sales Rep].[Sales Rep].&[TAYLOR], [Opportunity Status].[Opportunity Status].[Op Status].&[Open], [Probability].[Probability Description].[All Probability] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

I can send you my cube if this would expedite things.

|||

Hello Linda. I think that the problem relates to that you crossjoin several dimensions, one of them at the leaf level.

I do not know how many members you have in each dimensions but if you can do subtotals on the Adventure Works cube it is probably the design of the cube that decides this.

If you remove some dimensions in the crossjoin and only start with the first two? Will it work?

HTH

Thomas Ivarsson

|||

Hi,

There isn't a work around or hotfix for the problem, we had the same problem and users have been banded from including them in their queries.

Most of the time you don't need to use ProClarity's Total options, if you are selecting every child of an attribute, you can just include the all level as well and that will give you a total e.g.

All Opps

-opp1

-opp2

-opp3

SELECT { [Measures].[Measure1] } ON COLUMNS ,
{ [Dim].[Opps].[All Opps], [Dim].[Opps].&[Opp1], [Dim].[Opps].&[Opp2],[Dim].[Opps].&[Opp3] } ON ROWS
FROM [fact]

would give you an all level (total)

Measure

All 20

opp1 5

opp2 5

opp3 10

HTH

Matt

|||

Good point Mark but if the subtotal feature is usable or useless depends on how many cells that you call with several dimensions on an axis and on the leaf level.

No tool can manage that!

Regards

Thomas Ivarsson

|||

I was perhaps offereing a work around for the problem seeing as there wasn't a fix.

Mark AKA Matt

|||

Hello Matt. I will try your solution.

I have published several complaints about ProClarity's implementation of MDX on my blog.

Regards

Thomas Ivarsson

|||

Matt,

Linda

Thomas,

I took off the 3rd dimension (Opportunity) and the subtotals worked. Here is my MDX:

WITH MEMBER [Company].[Company].[All Companies].[ Subtotal]

AS ' AGGREGATE( EXISTING

{ DESCENDANTS( [Company].[Company].[All Companies], [Company].[Company].[Company] ) }) ',

SOLVE_ORDER = 1000

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

FROM [Daily Pipeline Snapshot]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

Linda

|||

Hi,

e,g, You code looks something like:

Code Snippet

WITH MEMBER [Campaign].[Campaign Region].[All Campaigns].[ Subtotal]

' AGGREGATE( EXISTING { [Campaign].[Campaign Region].[All Campaigns].CHILDREN }) ',

SOLVE_ORDER = 1000

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns].CHILDREN },

{ [Campaign].[Campaign Region].[All Campaigns].[ Subtotal] } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

mine looks something like

Code Snippet

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns]},

{ [Campaign].[Campaign Region].[All Campaigns].children } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

The only difference is I have an "All level" at the top and you have a "sub total" at the bottom.

The only down side to it as far as i can see it is if you don't include all the members of the dimension then the "All level" doesn't work.

You could always try caching the results (common ones) that way when your uses run their queries they hit the cache first. I believe chris webb has a blog on cache warming.

Matt

|||

Hello Linda! This one

Code Snippet

{ [Next 3 Months Anticipated Close] }

on columns is that a calculated member, calculated measure, named set or dimension member?

Regards

Thomas Ivarsson

|||

Thomas,

[Next 3 Months Anticipated Close] is a named set.

STRTOSET(

"[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0):
[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0).Lead(2)")

Where can I send the cube? I would like you to look at it and see if you get the same behavior I do.

Can Excel 2007 read cubes?

Linda

|||

Linda! Excel2007 supports all SSAS2005 features except writeback. Try that option first and see if it helps.

It can reveal if it is ProClarity's MDX that is the problem.

How large is the cube? If it is large you may have to place it on an FTP-site.

If you look at my profile you can see my email.

STRTOSET is not good for performance. Is that a dynamic,running month, set?

Regards

Thomas Ivarsson

Regards

Thomas Ivarsson

|||

Thomas,

We have Excel2007. I will install it and try it.

The data warehouse is 10,500 KB.

Yes, it is a dynamic running month set. What can I use instead of STRTOSET?

Thanks,

Linda

|||Linda! I have an example here: http://thomasianalytics.spaces.live.com/blog/cns!B6B6A40B93AE1393!352.entry

There are many other ways to solve this.

I think you can send the cube directly.

Regards

Thomas Ivarsson

ProClarity Desktop Professional 6.3 - Totals Performance

Thanks,

Linda Fleming

Hello Linda! I have not seen performance issues with ProClarity totals but can you send some more information regarding your problem?

Can you recreate the problem on the Adventure Works sample cube or can you tell us more about the structure of your cube?

Regards

Thomas Ivarsson

|||

Thomas,

(Note: I tried using a partition but did not make any difference because I think the problem is with the large number of dimension rows and not the fact table)

factTable: 200,000 rows.

I want subtotals in my view by Stage, but the query never returns.

All Companies has 1614 rows

All Opportunities has 406 rows

Here is my MDX:

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

FROM [Daily Pipeline Snapshot]

WHERE ( [Measures].[Opportunity Value], [Sales Rep].[Sales Rep].&[TAYLOR], [Opportunity Status].[Opportunity Status].[Op Status].&[Open], [Probability].[Probability Description].[All Probability] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

I can send you my cube if this would expedite things.

|||

Hello Linda. I think that the problem relates to that you crossjoin several dimensions, one of them at the leaf level.

I do not know how many members you have in each dimensions but if you can do subtotals on the Adventure Works cube it is probably the design of the cube that decides this.

If you remove some dimensions in the crossjoin and only start with the first two? Will it work?

HTH

Thomas Ivarsson

|||

Hi,

There isn't a work around or hotfix for the problem, we had the same problem and users have been banded from including them in their queries.

Most of the time you don't need to use ProClarity's Total options, if you are selecting every child of an attribute, you can just include the all level as well and that will give you a total e.g.

All Opps

-opp1

-opp2

-opp3

SELECT { [Measures].[Measure1] } ON COLUMNS ,
{ [Dim].[Opps].[All Opps], [Dim].[Opps].&[Opp1], [Dim].[Opps].&[Opp2],[Dim].[Opps].&[Opp3] } ON ROWS
FROM [fact]

would give you an all level (total)

Measure

All 20

opp1 5

opp2 5

opp3 10

HTH

Matt

|||

Good point Mark but if the subtotal feature is usable or useless depends on how many cells that you call with several dimensions on an axis and on the leaf level.

No tool can manage that!

Regards

Thomas Ivarsson

|||

I was perhaps offereing a work around for the problem seeing as there wasn't a fix.

Mark AKA Matt

|||

Hello Matt. I will try your solution.

I have published several complaints about ProClarity's implementation of MDX on my blog.

Regards

Thomas Ivarsson

|||

Matt,

Linda

Thomas,

I took off the 3rd dimension (Opportunity) and the subtotals worked. Here is my MDX:

WITH MEMBER [Company].[Company].[All Companies].[ Subtotal]

AS ' AGGREGATE( EXISTING

{ DESCENDANTS( [Company].[Company].[All Companies], [Company].[Company].[Company] ) }) ',

SOLVE_ORDER = 1000

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

FROM [Daily Pipeline Snapshot]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

Linda

|||

Hi,

e,g, You code looks something like:

Code Snippet

WITH MEMBER [Campaign].[Campaign Region].[All Campaigns].[ Subtotal]

' AGGREGATE( EXISTING { [Campaign].[Campaign Region].[All Campaigns].CHILDREN }) ',

SOLVE_ORDER = 1000

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns].CHILDREN },

{ [Campaign].[Campaign Region].[All Campaigns].[ Subtotal] } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

mine looks something like

Code Snippet

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns]},

{ [Campaign].[Campaign Region].[All Campaigns].children } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

The only difference is I have an "All level" at the top and you have a "sub total" at the bottom.

The only down side to it as far as i can see it is if you don't include all the members of the dimension then the "All level" doesn't work.

You could always try caching the results (common ones) that way when your uses run their queries they hit the cache first. I believe chris webb has a blog on cache warming.

Matt

|||

Hello Linda! This one

Code Snippet

{ [Next 3 Months Anticipated Close] }

on columns is that a calculated member, calculated measure, named set or dimension member?

Regards

Thomas Ivarsson

|||

Thomas,

[Next 3 Months Anticipated Close] is a named set.

STRTOSET(

"[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0):
[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0).Lead(2)")

Where can I send the cube? I would like you to look at it and see if you get the same behavior I do.

Can Excel 2007 read cubes?

Linda

|||

Linda! Excel2007 supports all SSAS2005 features except writeback. Try that option first and see if it helps.

It can reveal if it is ProClarity's MDX that is the problem.

How large is the cube? If it is large you may have to place it on an FTP-site.

If you look at my profile you can see my email.

STRTOSET is not good for performance. Is that a dynamic,running month, set?

Regards

Thomas Ivarsson

Regards

Thomas Ivarsson

|||

Thomas,

We have Excel2007. I will install it and try it.

The data warehouse is 10,500 KB.

Yes, it is a dynamic running month set. What can I use instead of STRTOSET?

Thanks,

Linda

|||Linda! I have an example here: http://thomasianalytics.spaces.live.com/blog/cns!B6B6A40B93AE1393!352.entry

There are many other ways to solve this.

I think you can send the cube directly.

Regards

Thomas Ivarsson

ProClarity Desktop Professional 6.3 - Totals Performance

Thanks,

Linda Fleming

Hello Linda! I have not seen performance issues with ProClarity totals but can you send some more information regarding your problem?

Can you recreate the problem on the Adventure Works sample cube or can you tell us more about the structure of your cube?

Regards

Thomas Ivarsson

|||

Thomas,

(Note: I tried using a partition but did not make any difference because I think the problem is with the large number of dimension rows and not the fact table)

factTable: 200,000 rows.

I want subtotals in my view by Stage, but the query never returns.

All Companies has 1614 rows

All Opportunities has 406 rows

Here is my MDX:

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

FROM [Daily Pipeline Snapshot]

WHERE ( [Measures].[Opportunity Value], [Sales Rep].[Sales Rep].&[TAYLOR], [Opportunity Status].[Opportunity Status].[Op Status].&[Open], [Probability].[Probability Description].[All Probability] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

I can send you my cube if this would expedite things.

|||

Hello Linda. I think that the problem relates to that you crossjoin several dimensions, one of them at the leaf level.

I do not know how many members you have in each dimensions but if you can do subtotals on the Adventure Works cube it is probably the design of the cube that decides this.

If you remove some dimensions in the crossjoin and only start with the first two? Will it work?

HTH

Thomas Ivarsson

|||

Hi,

There isn't a work around or hotfix for the problem, we had the same problem and users have been banded from including them in their queries.

Most of the time you don't need to use ProClarity's Total options, if you are selecting every child of an attribute, you can just include the all level as well and that will give you a total e.g.

All Opps

-opp1

-opp2

-opp3

SELECT { [Measures].[Measure1] } ON COLUMNS ,
{ [Dim].[Opps].[All Opps], [Dim].[Opps].&[Opp1], [Dim].[Opps].&[Opp2],[Dim].[Opps].&[Opp3] } ON ROWS
FROM [fact]

would give you an all level (total)

Measure

All 20

opp1 5

opp2 5

opp3 10

HTH

Matt

|||

Good point Mark but if the subtotal feature is usable or useless depends on how many cells that you call with several dimensions on an axis and on the leaf level.

No tool can manage that!

Regards

Thomas Ivarsson

|||

I was perhaps offereing a work around for the problem seeing as there wasn't a fix.

Mark AKA Matt

|||

Hello Matt. I will try your solution.

I have published several complaints about ProClarity's implementation of MDX on my blog.

Regards

Thomas Ivarsson

|||

Matt,

Linda

Thomas,

I took off the 3rd dimension (Opportunity) and the subtotals worked. Here is my MDX:

WITH MEMBER [Company].[Company].[All Companies].[ Subtotal]

AS ' AGGREGATE( EXISTING

{ DESCENDANTS( [Company].[Company].[All Companies], [Company].[Company].[Company] ) }) ',

SOLVE_ORDER = 1000

SELECT NON EMPTY { [Next 3 Months Anticipated Close] } ON COLUMNS ,

FROM [Daily Pipeline Snapshot]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

Linda

|||

Hi,

e,g, You code looks something like:

Code Snippet

WITH MEMBER [Campaign].[Campaign Region].[All Campaigns].[ Subtotal]

' AGGREGATE( EXISTING { [Campaign].[Campaign Region].[All Campaigns].CHILDREN }) ',

SOLVE_ORDER = 1000

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns].CHILDREN },

{ [Campaign].[Campaign Region].[All Campaigns].[ Subtotal] } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

mine looks something like

Code Snippet

SELECT { [Measures].[Charge Out] } ON COLUMNS ,

NON EMPTY { { [Campaign].[Regular Campaign Flag].&[0],

[Campaign].[Regular Campaign Flag].&[1.] } *

{ { [Campaign].[Campaign Region].[All Campaigns]},

{ [Campaign].[Campaign Region].[All Campaigns].children } } } ON ROWS

FROM [Self Service Prototype 3]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL

The only difference is I have an "All level" at the top and you have a "sub total" at the bottom.

The only down side to it as far as i can see it is if you don't include all the members of the dimension then the "All level" doesn't work.

You could always try caching the results (common ones) that way when your uses run their queries they hit the cache first. I believe chris webb has a blog on cache warming.

Matt

|||

Hello Linda! This one

Code Snippet

{ [Next 3 Months Anticipated Close] }

on columns is that a calculated member, calculated measure, named set or dimension member?

Regards

Thomas Ivarsson

|||

Thomas,

[Next 3 Months Anticipated Close] is a named set.

STRTOSET(

"[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0):
[Anticipated Close Date].[Hierarchy].[Month].&["

+ Format(Now(), "yyyy") + Format(Now(), "MM") + "].Item(0).Lead(2)")

Where can I send the cube? I would like you to look at it and see if you get the same behavior I do.

Can Excel 2007 read cubes?

Linda

|||

Linda! Excel2007 supports all SSAS2005 features except writeback. Try that option first and see if it helps.

It can reveal if it is ProClarity's MDX that is the problem.

How large is the cube? If it is large you may have to place it on an FTP-site.

If you look at my profile you can see my email.

STRTOSET is not good for performance. Is that a dynamic,running month, set?

Regards

Thomas Ivarsson

Regards

Thomas Ivarsson

|||

Thomas,

We have Excel2007. I will install it and try it.

The data warehouse is 10,500 KB.

Yes, it is a dynamic running month set. What can I use instead of STRTOSET?

Thanks,

Linda

|||Linda! I have an example here: http://thomasianalytics.spaces.live.com/blog/cns!B6B6A40B93AE1393!352.entry

There are many other ways to solve this.

I think you can send the cube directly.

Regards

Thomas Ivarssonsql

ProClarity Dashboard server user name and password modification

Hi, all experts here,

Does anyone know how can we change the password for a particular user of ProClarity dashboard server? I changed it from the ProClarity dashboard server database's 'users' table, but it does not work. Any one know how can we do that.

Thanks and I am looking forward to hearing from you.

With kind regards,

Yours sincerely,

Hello Helen. Dashboard Server is integrated with Active Directory. You map users into groups in AD and map that groups in Dashboard Server.

Normally you do not handle accounts and passwords in Dashboard Server with the exception of the dashboard administrator.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks for your kind advices.

Yes, I logged on as the administrator of the Server. What happened was the I logged on as administrator of the dashboard viewer successfully. But it did not let me log on to the dashboard studio with exactly the same administrator account. What I did was going to the database of the dashboard server and changed the password for this administrator account. But it did not let me log on with the reset password again. I am still stuck in it.

Thanks for your help anyway.

With kind regards,

Yours sincerely,

|||

OK. You can always reinstall Dashboard Server once again and get the option to change the password.

I suspect that the integration with Active Directory is not done correctly. I think you will need the help of an it-support specialist. The installation of this product is a little bit tricky.

Changing password directly in a table will usually not work.

Edit: It is possible to change the password for the PDS administrator by changing authentication back to SQL Server /forms authentication and use the default admin id and password. You will have to configure some xml files to do that and make an authentication change in Internet Information Server(IIS).

This is in the documentation.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks for your help.

With kind regards,

Yours sincerely,

ProClarity Dashboard server user name and password modification

Hi, all experts here,

Thanks and I am looking forward to hearing from you.

With kind regards,

Yours sincerely,

Hello Helen. Dashboard Server is integrated with Active Directory. You map users into groups in AD and map that groups in Dashboard Server.

Normally you do not handle accounts and passwords in Dashboard Server with the exception of the dashboard administrator.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks for your kind advices.

Thanks for your help anyway.

With kind regards,

Yours sincerely,

|||

OK. You can always reinstall Dashboard Server once again and get the option to change the password.

I suspect that the integration with Active Directory is not done correctly. I think you will need the help of an it-support specialist. The installation of this product is a little bit tricky.

Changing password directly in a table will usually not work.

This is in the documentation.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks for your help.

With kind regards,

Yours sincerely,

ProClarity Dashboard server user name and password modification

Hi, all experts here,

Thanks and I am looking forward to hearing from you.

With kind regards,

Yours sincerely,

Hello Helen. Dashboard Server is integrated with Active Directory. You map users into groups in AD and map that groups in Dashboard Server.

Normally you do not handle accounts and passwords in Dashboard Server with the exception of the dashboard administrator.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks for your kind advices.

Thanks for your help anyway.

With kind regards,

Yours sincerely,

|||

OK. You can always reinstall Dashboard Server once again and get the option to change the password.

I suspect that the integration with Active Directory is not done correctly. I think you will need the help of an it-support specialist. The installation of this product is a little bit tricky.

Changing password directly in a table will usually not work.

This is in the documentation.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks for your help.

With kind regards,

Yours sincerely,

Proclarity Dashboard Performance issues

Hi,

I had a problem with the performance. It generally takes time for all the application to populate the content in the window when it was called first time and for sucessive calls it will populate the page quickly. but in case of my proclarity dashboard it takes more time when it was called as many times. can anyone help me to resolve this problem.

Thanks,

madhan

Are you saying that the second time you displayed a page from RS, it took as long as the first time? If so check the log file and see if the appdomain was recycled. There is "shutdownReason" in the log file that may be of interest. Make sure you are not touching any file under the RS directory each time you load your dashboard.

ProClarity and Windows Vista

I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?
Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/details.aspx?FamilyID=7a65e401-b298-46c6-a370-ce9d65d4fb21&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issues
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?
sql

ProClarity and Windows Vista

I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this issue and found a resolution?Hello.
Did you mean ProClarity Desktop? There is hotfix for this :
http://www.microsoft.com/downloads/...&DisplayLang=en
And checks. As I know, hotfix for ProClarity Analytics released as well.
+--
Kenial.GhostOnNetwork.
Darren wrote:
> I have recently moved over to Windows Vista Business Edition and have issu
es
> with the installation of ProClarity 6.1 (also with v6.3).
> Having installed ProClarity, I find that it fails to launch. All I get is
a
> Windows message stating that it has stopped working.
> Has anyone else had this issue and found a resolution?

Proclarity and SQL Server 2005

Hi All,

3 Proclarity Selector – Purpose of this tool?

4. Why is that Proclarity Dashboard server? We can create a view of dashboard using Sharepoint. Not sure about the advantage of this.

Regards, Kart

Hello!

1. This is a project that is added to the SSRS designer in BI-DEV studio. It will start up a ProClarity professional interface in Reporting services and also help you with formatting the report.

3. This tool helps you with building named sets, like the top 10 best selling products.

HTH

Thomas Ivarsson

|||

Hi Thomas,

Thanks for the Info.

1. When you say Proclarity for Reporting Services.is a project used for formatting reports, how it benifits us. We can do formatting in BI studio of SSRS.

3. I hope it is added as a add-on (menu item in toolbar) of Proclarity Designer

4. Got it.

Regards, kart

|||

1. The ProClarity designer in SSRS2005 is better than Reporting Services own. It is a matter of taste.

3. Selector is placed on the toolbar. It is a part of the Business Logic Server if you install that.

Regards

Thomas Ivarsson

|||

Hi Thomas,

Thanks again and I got good clarity on Proclarity now.

Regards, Kart

|||

Hi,

In my humble opinion, you should not prefer to use BSM KPIs when you plan to use SSAS2005 as target.

BSM KPIs have many advantatges if you need to define KPIs based on ODBC datasources, Excel or just type the values manually.

HTH,

Jordi Rambla

Solid Quality Learning

|||

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

|||

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

|||

Hello Jordi,

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

Proclarity and SQL Server 2005

Hi All,

3 Proclarity Selector – Purpose of this tool?

4. Why is that Proclarity Dashboard server? We can create a view of dashboard using Sharepoint. Not sure about the advantage of this.

Regards, Kart

Hello!

1. This is a project that is added to the SSRS designer in BI-DEV studio. It will start up a ProClarity professional interface in Reporting services and also help you with formatting the report.

3. This tool helps you with building named sets, like the top 10 best selling products.

HTH

Thomas Ivarsson

|||

Hi Thomas,

Thanks for the Info.

1. When you say Proclarity for Reporting Services.is a project used for formatting reports, how it benifits us. We can do formatting in BI studio of SSRS.

3. I hope it is added as a add-on (menu item in toolbar) of Proclarity Designer

4. Got it.

Regards, kart

|||

1. The ProClarity designer in SSRS2005 is better than Reporting Services own. It is a matter of taste.

3. Selector is placed on the toolbar. It is a part of the Business Logic Server if you install that.

Regards

Thomas Ivarsson

|||

Hi Thomas,

Thanks again and I got good clarity on Proclarity now.

Regards, Kart

|||

Hi,

In my humble opinion, you should not prefer to use BSM KPIs when you plan to use SSAS2005 as target.

BSM KPIs have many advantatges if you need to define KPIs based on ODBC datasources, Excel or just type the values manually.

HTH,

Jordi Rambla

Solid Quality Learning

|||

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

|||

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

|||

Hello Jordi,

If hired fulltime, we pay you $500 for any referrals that are hired.

I hope to hear from you soon!

Best Regards,

Lynsey Moore

Lynsey Moore

Recruiting Specialist

713.395.7150 | Phone

713.395-7130 | Fax

www.catapultsystems.com

CATAPULT SYSTEMS INC.

ENABLING BUSINESS THROUGH TECHNOLOGY

ProClarity and Dundas

Will these two products (ProClarity and Dundas) be incorporated in some way into SSRS, and how they will be used?

will there in katmai be the barcodes from dundas?

regards

andreas

|||

Dundas will be integrated into Reporting Services Katmai. We are working on getting all of the components integrated but chart will be there for sure.

ProClarity is getting integrated into PerformancePoint (see http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx).

|||

I hate to ask, but I HOPE I can use this feature. Will Dundas be enabled for SQL Server 2005/2008 Express and with Visual Studio Express?

Thanks,

Michael

|||

I'd still like an answer on this one.

Thanks!

Michael

Friday, March 23, 2012

ProClarity: Is there any way we can use tables as sources of ProClarity views instead of cubes?

ProClarity Slicersel parameters

Proclarity reports

proclarity question

Proclarity Installation using SQL Server 2005

Proclarity Installation

ProClarity Expert Needed for our BI Team - Texas Job Opportunity

ProClarity Desktop Professional 6.3 - Totals Performance

ProClarity Desktop Professional 6.3 - Totals Performance

ProClarity Desktop Professional 6.3 - Totals Performance

ProClarity Desktop Professional 6.3 - Totals Performance

ProClarity Dashboard server user name and password modification

ProClarity Dashboard server user name and password modification

ProClarity Dashboard server user name and password modification

Proclarity Dashboard Performance issues

ProClarity and Windows Vista

ProClarity and Windows Vista

Proclarity and SQL Server 2005

Proclarity and SQL Server 2005

ProClarity and Dundas

Procedure Time out

Blog Archive

About Me